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

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

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

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

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