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