MrExcel Publishing
Your One Stop for Excel Tips & Solutions

using macro to insert non-dymanic time and date / seperate columns

Posted by Jason Davis on October 09, 2001 3:17 PM

How do I get a macro to insert the date and time into
two seperate cells. When the macro is run it will get the current date and time and log it in a cell.
The now() is a dynamic value which changes. I only want the actual date and time the macro is run.

Any help would be appericated.

Posted by Francisco Gento on October 09, 2001 4:11 PM

Range("A1").Value = Date
Range("A1").NumberFormat = "mm\/dd\/yy"
Range("A2").Value = Time
Range("A2").NumberFormat = "hh:mm:ss"