| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Cell - Remember
Thanks all,
Guidance much appreciated. Paul. "Stefi" wrote in message ... Clever! Regards, Stefi "Pete" ezt ķrta: Before sorting you could use a blank column and fill this with the sequence 1,2,3 etc. Include this column in your sort range. Then if the active cell had been C504, you just need to search for 504 in this helper column - the column can be deleted when not needed. Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Can a cell remember a number?... | Excel Discussion (Misc queries) | |||
| Why and How Does Excel Remember The Last Cell? | Excel Worksheet Functions | |||
| How do I get a cell to remember the last entry and add to it? | Excel Discussion (Misc queries) | |||
| Remember a cell | Excel Programming | |||
![Paul Brown[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
