I'd like excel to write the time when one of my macros tells it to copy and paste some cells into another workbook. I'd like it to paste the time into the other workbook. Any help would be much appreciated.

Recommended Answers

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbadev/html/exactlywhenisit.asp

Try this.

If you're not up for reading it, the code would be:

Sub CopyWorksheet_Click()

Range("A1").FormulaR1C1 = Now

End Sub

Jump to Post

All 3 Replies

sorry, didnt read the whole thing!
cheers man

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.