WestwegoMans' Forum

Computers, Websites & Forums => MS Excel => Topic started by: WestwegoMan on Jan 23, 2015, 5:01 PM

Title: Mark current date and time in a specific cell. (VBA)
Post by: WestwegoMan on Jan 23, 2015, 5:01 PM

This macro will mark the current time from the PC into cell "I2"

Code: [Select]

Workbooks("Test.xls").Sheets("Main").Cells(2, "I") = Date & "  " & Time

Text Only | Text with Attachments