Re: Scrolling a spreadsheet with a macro

On 05.03.2011 01:06, Johnny Rosenberg wrote:
> I just ran into a problem doing this. The problem is that I have ”fixed”
> the sheet, so I am always able to see the first rows and the first
> column, so the A column and the 4 first rows are always visible.
>
> I always want A1 to be selected, keeping the selection out of the
> important area. However, A1 is above the ”fix point” and therefore I
> can't scroll unless I first select a cell below the ”fix point” and then
> reselect A1 again.

There's no need to change the selection. If the view is split or frozen, 
you can use the XIndexAccess interface to get the individual panes. 
Something like this:
oPane = oView(1)
oPane.FirstVisibleRow = 6

Niklas
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help