| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
frozen panes question
i have the panes frozen at row 19.
in the bottom pane, i want row 531 to be the top line how can i do this when i save the workbook, so it always opens like this? seems to work if i manually type a531 in the name box -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
frozen panes question
will this work all of the time?
Application.Goto Reference:="R531C1" -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i have the panes frozen at row 19. in the bottom pane, i want row 531 to be the top line how can i do this when i save the workbook, so it always opens like this? seems to work if i manually type a531 in the name box -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
frozen panes question
No it won't necessarily. For instance, if there are 20 lines visible in the
lower pane, and you go to row 531, it will make 531 visible, but at the bottom of the window. One way is to go way beyond it, that couldn't possibly be visible, then come back Application.Goto Reference:="R1000C1" Application.Goto Reference:="R531C1" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... will this work all of the time? Application.Goto Reference:="R531C1" -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i have the panes frozen at row 19. in the bottom pane, i want row 531 to be the top line how can i do this when i save the workbook, so it always opens like this? seems to work if i manually type a531 in the name box -- Gary |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
frozen panes question
Gary,
Setting the 2nd argument Scroll:=True seems to work. NickHK "Gary Keramidas" <GKeramidasATmsn.com bl... will this work all of the time? Application.Goto Reference:="R531C1" -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i have the panes frozen at row 19. in the bottom pane, i want row 531 to be the top line how can i do this when i save the workbook, so it always opens like this? seems to work if i manually type a531 in the name box -- Gary |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
frozen panes question
ok, thanks to both of you. seems to work
-- Gary "NickHK" wrote in message ... Gary, Setting the 2nd argument Scroll:=True seems to work. NickHK "Gary Keramidas" <GKeramidasATmsn.com bl... will this work all of the time? Application.Goto Reference:="R531C1" -- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... i have the panes frozen at row 19. in the bottom pane, i want row 531 to be the top line how can i do this when i save the workbook, so it always opens like this? seems to work if i manually type a531 in the name box -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting issue with frozen panes | Excel Discussion (Misc queries) | |||
| Print Frozen Panes? | Excel Discussion (Misc queries) | |||
| frozen panes | Excel Discussion (Misc queries) | |||
| Drop down list & frozen panes | Excel Discussion (Misc queries) | |||
| How do i use multiple splits or frozen panes? | Excel Discussion (Misc queries) | |||
Linear Mode
