Hi,
A simpler alternative for your second requirement:
ActiveWindow.ScrollRow = 50
Regards - Dave.
> Date: Tue, 28 Sep 2010 16:08:14 -0700
> Subject: $$Excel-Macros$$ Visible Row Below Freeze Pane
> From: spa...@corbetteer.co.uk
> To: excel-macros@googlegroups.com
>
>
27;s probably a better way of doing the second one, but this is all I could
think of tonight.
Regards - Dave.
> Date: Tue, 28 Sep 2010 16:08:14 -0700
> Subject: $$Excel-Macros$$ Visible Row Below Freeze Pane
> From: spa...@corbetteer.co.uk
> To: excel-macros@googlegroups.com
>
With the top row frozen and the sheet scrolled down so that the first
visible row below row 1 is row 32.
How would I prove row 32 is the first visible row through VBA
If i then wanted to make row 50 the first visible row, how could it be
done through VBA
--
-
