View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
G Lykos G Lykos is offline
external usenet poster
 
Posts: 74
Default VBA equiv. of Ctrl-Home w/Freeze Panes?

Thanks nonetheless. The elegance of the structure is giving me something to
think about.


"Rick Rothstein (MVP - VB)" wrote in
message ...
Never mind... I grabbed the wrong code from my library... this one just

put
the cursor at the split point of the currently scrolled window, not back

to
the home position. The code you posted is what I have for the going back

to
the home position.

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
Give this a try...

With ActiveWindow.Panes(ActiveWindow.Panes.Count)
ActiveSheet.Cells(.ScrollRow, .ScrollColumn).Select
End With

Rick


"G Lykos" wrote in message
...
Thanks,
George