just save it to a variable

prevValue = range("A1").value

you're not very specific as to waht you want to do with it and where it is?

--


Gary


"Moskms" wrote in message
...
I have a range of cell values, containing numbers from differet projects.

My problem is, if one of the numbers is changes I would like to catch the
previus number before the new number change the value in the cells.

That is if a cell contain the value 160 and the new value in the cell
will be 245 I would like to catch the number 160 with som kind of
funktion.

/Morten