View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Smith[_2_] Jeff Smith[_2_] is offline
external usenet poster
 
Posts: 17
Default How to locate a cell in the absolute A1 position

Hi,
I have a workbook with about 10 spreadsheets. There are several named
ranges and each sheet is about 20 cols x up to 200 rows. Unless I
discipline myself to Ctrl+Home before leaving each sheet, the next time I
enter the sheet the cursor may be "anywhere" (i.e. where I was last).

I need to find a way to easily reorientate a sheet to get the AI in the top
left corner; (similarly for a named range).

Is there a way of inserting some code into the "navigation" macros so that
at each point od entry, it is controllable and predictable.

Thanking you in anticipation (you guys have been a massive help to my
learning and development),

Jeff Smith