View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
noyb noyb is offline
external usenet poster
 
Posts: 7
Default Home or Ctrl-Home

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