Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll the window to the top - frozen rows
you could try Application.Goto [A4], True where A4 is the cell below your frozen row pane. Look up the [Goto Method] in your VBA Help files for more info -- Ivan F Moal ----------------------------------------------------------------------- Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195 View this thread: http://www.excelforum.com/showthread.php?threadid=26968 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scroll the window to the top - frozen rows
MDW
Try [A2].Select [A1].Select The A2 returns you to below your frozen row The A1 becomes ActiveCell. HTH Bob C "MDW" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |