Sub NOWENTRY()
'
Please help with my macro to enter current time and date into any cell I
choose. It always goes back to the cell in the macro and I want it to work
for the current cell the cursor is sitting on when I hit Ctrl+n.
My Macro:
' NOWENTRY Macro
' Enters current time and date
'
'
try this
Sub test()
Range(B5029).Value = Now()
End Sub
On Tue, May 24, 2011 at 8:39 PM, John A. Smith johnasmit...@gmail.comwrote:
Sub NOWENTRY()
'
Please help with my macro to enter current time and date into any cell I
choose. It always goes back to the cell in the macro and I want
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
From: John A. Smith johnasmit...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, 24 May, 2011 4:09:51 PM
Subject: $$Excel-Macros$$ Macro to Enter Current Time and Date
Sub
Excellent! Thank you very Much!
John
On Tue, May 24, 2011 at 11:44 AM, ashish koul koul.ash...@gmail.com wrote:
try this
Sub test()
ActiveCell.Value = Now()
End Sub
or
Sub test()
Range(B5029).Value = Now()
End Sub
On Tue, May 24, 2011 at 8:39 PM, John A. Smith