Left Property Example

This example scrolls to the left through the spreadsheet window to display cell F1 if this cell is currently to the left of the visible range.

Set r = Spreadsheet1.Range("f1")
If r.Left < 0 Then Spreadsheet1.ActiveSheet.Scroll r