Scroll the window to the top - frozen rows
Hey all,
I've got some code that marches down a bunch of cells (about 700 rows) and
applies formatting and formulas. When it's done, I want it to jump back up to
the top. I was able to simply say
ActiveWorksheet.Range("A1").Select
to do what I wanted.
However, I froze the first row because it contains column headers. Now I
can't get the window to go back to the top. I've tried
ActiveWindow.ScrollRow = 1
and
ActiveWindow.ScrollRow = 2 (Only the first row is frozen).
Neither of them work. Any ideas?
--
Hmm...they have the Internet on COMPUTERS now!
|