Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
Excellent! Thank you very Much!
John
On Tue, May 24, 2011 at 11:44 AM, ashish koul 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 wrote:
>>
>>> 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> 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
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
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
>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
Re: $$Excel-Macros$$ Macro to Enter Current Time and Date
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 wrote:
>
>> 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
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com
>
>
> P Before printing, think about the environment.
>
>
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
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
Re: $$Excel-Macros$$ Macro to Enter 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 wrote:
> 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
>
--
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com
P Before printing, think about the environment.
--
--
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
$$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
