View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wim hoevenaren wim hoevenaren is offline
external usenet poster
 
Posts: 1
Default Getting the previous cell value after changing a cell

In VB I want to write a script that provides me with the row and column
information of a changed cell.
This can be done with
worksheet_change(ByVal Target as Range)

Target.row and Target.column provides the row and column information of
the changed cell. Target.value provides me with the new updated cell
value.

However, I also want to have the previous cell value of the changed
cell. How can I get this previous cell value?

Regards

wim.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!