| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last updated cell
I need to create a conditional lookup depending on what is put in a cell. I
have managed to solve this with an array, however this needs to happen for more than one cell so is there anyway to know which the last updated cell in a column is? As this will allow me to change the array. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last updated cell
I think you'll need to be looking at the Worksheet's Change event where
'Target' is the range just changed. -- p45cal "Chris Rees" wrote: I need to create a conditional lookup depending on what is put in a cell. I have managed to solve this with an array, however this needs to happen for more than one cell so is there anyway to know which the last updated cell in a column is? As this will allow me to change the array. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When was this cell updated? | Excel Discussion (Misc queries) | |||
| cell for date last updated | Excel Worksheet Functions | |||
| Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
| Time or row cell updated | Excel Worksheet Functions | |||
| Run a macro when a cell is updated | Excel Programming | |||
Linear Mode
