943,929 Members | Top Members by Rank

Ad:
Oct 29th, 2005
0

Making Excel record a the time

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
grandfilth is offline Offline
16 posts
since Sep 2005
Oct 29th, 2005
0

Re: Making Excel record a the time

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
Reputation Points: 15
Solved Threads: 2
Newbie Poster
SlyMaelstrom is offline Offline
21 posts
since Oct 2005
Oct 29th, 2005
0

Re: Making Excel record a the time

Quote 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?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
grandfilth is offline Offline
16 posts
since Sep 2005
Oct 29th, 2005
0

Re: Making Excel record a the time

sorry, didnt read the whole thing!
cheers man
Reputation Points: 10
Solved Threads: 0
Newbie Poster
grandfilth is offline Offline
16 posts
since Sep 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: VHS demagnitizer
Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: making of cd player





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC