DaniWeb IT Discussion Community - View Single Post

•

Join Date: Sep 2005

Posts: 16

Reputation: grandfilth is an unknown quantity at this point

Solved Threads: 0

grandfilth grandfilth is offline

Offline

Newbie Poster

Re: Making Excel record a the time

Oct 29th, 2005

•

Originally Posted by SlyMaelstrom

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

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?