Automatically update date if cells change

[alan1203]

Is there an easy way of entering the date in a cell if any of the cells in a range are changed?
For example
If any of the cells in range A2:G2 are changed then H2 = the date that the cells were updated. Hope this makes sense.
Thanks, Alan

 

[AnotherHiggins]

see thread68-1569946

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[AnotherHiggins]

I should cut to the chase and say that while it may be technically possible to do this without VBA, you will be safest to just use VBA.

Please post a new question in forum707.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.