Thanks for the help Rajesh, However I forgot to mention one thing..
I am going to save this file with value from that cell (date and time
stamp). But I dont want the value in that cell with date and time stamp to
update everytime with current date and time when I open any previous saved
file.
Sorry for the confusion before

Hope I made it clear

THanks in advance


"Rajesh Mehmi" wrote:

Hi Sam

=Now() in cell will work, but it will keep updating date & time as the
spreadsheet is recalculated.

The code below will put the date & time in cell A1 on sheet1 and will not
get updated as the spreadsheet is recalculated.

Private Sub Workbook_Open()
Sheets(1).Cells(1, 1).Value = Now()
End Sub

Hope it helps
Best regards
Rajesh Mehmi



"sam" wrote in message
...
Hi All,

Is there a way I can display Current Date & Time in a cell which updates
everytime I open the workbook?

Thanks in Advance