Making Excel record a the time
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Thread Solved
 |
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.
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
Try this.
If you're not up for reading it, the code would be:
Sub CopyWorksheet_Click()
Range("A1").FormulaR1C1 = Now
End Sub
•
•
•
•
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?
|
Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Forgot Password Cant Get Into Computer (Windows NT / 2000 / XP / 2003)
- Good Luck w/This one: Excel Question VBA/Macro/other (MS Access and FileMaker Pro)
- What am i making? (PHP)
- Excel to Web in Real Time? (ASP)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VHS demagnitizer
- Next Thread: making of cd player
•
•
•
•
Views: 3368 | Replies: 3 | Currently Viewing: 1 (0 members and 1 guests)
Linear Mode
