Need code for simple change event
I want to run a simple If..Then based on a change to a range of cells
containing text. Basically something like this
If Range("E50:E100") changes Then
Range("A3") = Now()
End if
So if the text changes in the range the date of the document updates
to the system date. Seems like it should be simple but I can't figure
out how to do it. Any help appreciated.
Jake
|