Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
headers frozen so that when you scroll they stay | Excel Discussion (Misc queries) | |||
Scroll bar disappears when panes frozen | Excel Discussion (Misc queries) | |||
Frozen rows | New Users to Excel | |||
The top six rows are "frozen" and do not move when I scroll down.. | Excel Worksheet Functions | |||
Printing Frozen Rows | Excel Discussion (Misc queries) |