yes, you just reference the sheet main and the cell that you want to put the date in and make it's value = to Now
[VBA] Sheets("Main").Range("C6").Value = Now[/VBA]
yes, you just reference the sheet main and the cell that you want to put the date in and make it's value = to Now
[VBA] Sheets("Main").Range("C6").Value = Now[/VBA]
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln