Excel Macro - Ctrl-Home

[Yevette]

Hello All,

What is the excel vbe code to move the cell pointer to the top left (home) of a frozen pane? I need the same effect as ctrl-home would have without the cell reference as the location of the frozen pane will change constantly. Hope this is clear. Thanks a lot for your help

 

[Skyhigh]

Yevette,
Sorry its not clear, but if I understand you correctly, a simple use of "??=??" will do.

 

[tomds]

One VBa equivalent of CtrlHome in Excel would be Range("A1&quot.Select. I don't know if this is what you are looking for, though.

 

[sinkva]

The VBA / VB / Visual Basic equivalent of the
ctrl-home keyboard shortcut in Excel
that works for split / frozen window panes is:

cells(activewindow.splitrow + 1, activewindow.splitcolumn + 1).select

You might want to check the split and freeze state of the window, too.