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.

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.