View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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