how do i insert an auto updated - date

hi guys,

how do i create a cell that will always have the current date in it?

thank you

HI frnd,


Try this code...

currdate = Application.Text(Now(), "mm/dd/yy HH:MM")
Sheets("Pricing Worksheet").Range("$L$5") = currdate

Thanks & regards
u r frnd...