Select specific location in spreadsheet
Sorry, that needs to be:
ActiveWindow.Panes(2).ScrollRow = 10
ActiveWindow.Panes(2).ScrollColumn = 5
Not:
ActiveWindow.Pane(2).ScrollRow = 10
ActiveWindow.Pane(2).ScrollColumn = 5
Tom
"tompl" wrote:
You can set the cell that you want in the upper left corner of the
ActiveWindow or the ActivePane with the following language:
ActiveWindow.ScrollRow = 10 Row 10
ActiveWindow.ScrollColumn = 5 Column E
Or:
ActiveWindow.Pane(2).ScrollRow = 10
ActiveWindow.Pane(2).ScrollColumn = 5
You would need to test the Pane part because I am not too sure how it
would workin your specific worksheet.
tom
|