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.
grandfilth
0
Newbie Poster
Recommended Answers
Jump to Posthttp://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
All 3 Replies
SlyMaelstrom
5
Newbie Poster
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
grandfilth
0
Newbie Poster
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
How do you make this work though? Sorry I'm a bit thick! How would I put this into a function so that a cell would read the time?
grandfilth
0
Newbie Poster
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 meeting, networking, learning, and sharing knowledge.