DaniWeb IT Discussion Community - View Single Post

•

Join Date: Oct 2005

Posts: 21

Reputation: SlyMaelstrom is an unknown quantity at this point

Solved Threads: 2

SlyMaelstrom SlyMaelstrom is offline

Offline

Newbie Poster

Re: Making Excel record a the time

Oct 29th, 2005

http://msdn.microsoft.com/library/de...lywhenisit.asp

Try this.

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

Sub CopyWorksheet_Click()

Range("A1").FormulaR1C1 = Now

End Sub