Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro: Insert Blank Row with formulas uses absolute position probl | Excel Discussion (Misc queries) | |||
Absolute cell reference will not remain absolute. | Excel Worksheet Functions | |||
Locate last cell in column | Excel Discussion (Misc queries) | |||
Formula to locate a cell | Excel Discussion (Misc queries) | |||
Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) |