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.