Use VBA code to scroll an Excel worksheet's pane to a particular column

[nandagopal]

Find the pane that you want to scroll. In this example, it's the second of two panes. Set its ScrollColumn property to the column number that you want scrolled to the left edge of the pane.

Code Select Expand

Sub ScrollToQuizzes()
    ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollColumn _
        = 41
End Sub