VBA equiv. of Ctrl-Home w/Freeze Panes?

  • Thread starter Thread starter G Lykos
  • Start date Start date
May have answered my own question:

ActiveSheet.Cells(ActiveWindow.SplitRow+1,
ActiveWindow.SplitColumn+1).Select

Please let me know if any other ideas.

Thanks again,
George
 
Give this a try...

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

Rick
 
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
 
Thanks nonetheless. The elegance of the structure is giving me something to
think about.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Freeze panes 4
Freezed Panes and CTRL+HOME 1
freeze panes from vba 2
Range variables and Freeze Panes 3
Excel Freeze panes in Excel 3
Freeze Panes loss 3
Freeze Panes 2
FreezePanes from VBA? 8

Back
Top