Ardus:

Sorry, your post is much easier than mine, I got carried away and made
it complicated.

It obviously doesnt go into an indefinate loop because you are not
selecting, I selected as from experiance when i put now() in it updated
so I had to paste as value, but in this case is not needed.

maybe mine is a little too complicated.......

Duncan


Ardus Petus wrote:

Hi Leo,

Paste the following code in your worksheet's code (right-click on tab,
select View code)

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A1").Value = Date
Application.EnableEvents = True
End Sub


HTH
--
AP

"leonidas" a écrit
dans le message de news:
...

Hi,

I have a worksheet in excel with a lot of data on it. The data exists
of text, numbers and formulas.
I also have a date which should be updated to todays date when any of
the cell on the worksheet is changed.
Is it possible to do this and how should the code look like?
Thanks in advance for helping me!


--
leonidas
------------------------------------------------------------------------
leonidas's Profile:
http://www.excelforum.com/member.php...o&userid=35375
View this thread: http://www.excelforum.com/showthread...hreadid=561410