Charlie,

This takes you to the top left of the "displayed" page but does not force to
the same place that <Ctrl <Home does (the top/left corner of the "unfrozen"
pane). My macro hides/reveals certain columns and I want to set the cursor
the top/left of the "unfrozen" window as determined by the "Freeze Panes"
command (i.e. regardless of where the cursor has been scrolled to and
regardless of the presence/absence of hidden columns).

I have tried to use SendKeys but am having difficulty get the code to work
reliably given my limited knowledge/experience.

Anyone have a suggestion?

"Charlie" wrote:

It took me forever and a day to find this one...

Cells(ActiveWindow.ActivePane.ScrollRow,
ActiveWindow.ActivePane.ScrollColumn).Select



"noyb" wrote:

Thanks, but, let me restate. I have a number of worksheets I want to
cycle through and get the selected cell to the top left of the
non-frozen part of each sheet. The number of frozen rows and columns
differs from sheet to sheet. Is it possible to so this without having to
hard code the location for each sheet. ie: the vba equivalent of
"Ctrl+Home" with frozen panes.
Thanks again

Chip Pearson wrote:
Home =
Cells(ActiveCell.Row,"A").Select

Ctrl+Home=
Range("A1").Select