Record current time


Posted by roostir on August 10, 2001 7:04 PM

I have a simple macro which tabs over several columns, inserts a "1" and then returns to the next line. I would like the macro to record the current time in the first cell before I begin to tab over. I have tried recording the "ctrl-shift-;" to simply input the current time, but the macro only keeps the time from when the macro was recorded. I've also tried the "=now()' command but then all my rows just constantly update to the current time. I need a separate record of time for each row. Any suggestions?



Posted by Ivan F Moala on August 10, 2001 7:18 PM

In your code before Tabing over just put in

Range("yourrange")= Now

Ivan