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
|