jus delete Range("B5029").Select
so your macro will b like this.
you have recorded this macro. record it again but just delete that Range thing
' NOWENTRY Macro
' Enters current time and date
'
' Keyboard Shortcut: Ctrl+n
'
ActiveCell.FormulaR1C1 = "=NOW()"
Selection.Copy
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 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
>'
>' Keyboard Shortcut: Ctrl+n
>'
> Range("B5029").Select
> ActiveCell.FormulaR1C1 = "=NOW()"
> Range("B5029").Select
> Selection.Copy
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks
_
> :=False, Transpose:=False
>End Sub
>
>Thank you again for your help.
>
>John--
>----------------------------------------------------------------------------------
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links :
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
