Re: Scrolling a spreadsheet with a macro

On 04.03.2011 17:18, Johnny Rosenberg wrote:
> Have been looking for it with Xray, but so far I didn't find anything
> that I think does what I want.
>
> What I want to do is to search for a cell. When I find it, I want it to
> appear as the first row and the the first column. Let's say that I find
> what I'm looking for in C7. Then I want the sheet to scroll so that it
> appears like this:
>
> C D E F G H I J…
> 7
> 8
> 9
> 10
> 11
> 12
> 13
> 14
> 15
> ⁝

Use the view's XViewPane interface. In Basic that's just
oView.FirstVisibleColumn = 2
oView.FirstVisibleRow = 6

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