frozen panes question

[Gary Keramidas]

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 Keramidas]

will this work all of the time?

Application.Goto Reference:="R531C1"

 

[Bob Phillips]

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)

 

[NickHK]

Gary,
Setting the 2nd argument Scroll:=True seems to work.

NickHK

 

[Gary Keramidas]

ok, thanks to both of you. seems to work