Hi,
How would I prove row 32 is the first visible row through VBA
A = Activewindow.VisibleRange.Row
If i then wanted to make row 50 the first visible row, how could it be done
through VBA
Range(A2).Select
ActiveWindow.SmallScroll Down:=48
There's probably a better way of doing the
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
With the top row