Hi,

I need my excel file to automatically enter date and time at 2 specific cell (separately).
Eg : Date at cell "AF5" & time at cell "AF6"

Currently I'm using following code for manually entering time :
ActiveCell.Value = Time()

Thanks in advance :-)