|
|
|
| Title | Use VBA code to scroll an Excel worksheet's pane to a particular column |
|---|
| Description | This example shows how to use VBA code to scroll an Excel worksheet's pane to a particular column. |
|---|
| Keywords | Excel, scroll, column, worksheet, workbook |
|---|
| Categories | Office, Miscellany |
|---|
|
|
|
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.
|
|
Sub ScrollToQuizzes()
ActiveWindow.Panes(ActiveWindow.Panes.Count).ScrollColumn _
= 41
End Sub
|
| |
 |
| |
|
|
