TODAY function?
I'm sure by now this question has been resolved for Michael, so this is for
the next guy of gal. Note that the Macro names are mine and yours will look different. Good luck. Chris Sub Macro3() ' ' Macro3 Macro ' Macro recorded Your Date< by Your Name< ' ' Keyboard Shortcut: Your Choice< ' Range("A3").Select ActiveCell.FormulaR1C1 = "=TODAY()" Range("A3") = Date Application.Run "'Your Book Name'!CheckEntry" End Sub "Niek Otten" wrote: Hi Michelle, Range("A3")=Date() -- Kind Regards, Niek Otten Microsoft MVP - Excel "Michelle Tucker" wrote in message ... I am creating a macro which will insert a row, then insert text in the first two cells. In the 3rd cell I want it to insert todays date. But if I use the TODAY function, the date will change all the time. Is there another function that will just insert todays date, but not change? -- Michelle Tucker |
I'm sure by now this question has been resolved for Michael, so this is for
the next guy of gal. Note that the Macro names are mine and yours will look different. Good luck. Chris Sub Macro3() ' ' Macro3 Macro ' Macro recorded Your Date< by Your Name< ' ' Keyboard Shortcut: Your Choice< ' Range("A3").Select ActiveCell.FormulaR1C1 = "=TODAY()" Range("A3") = Date Application.Run "'Your Book Name'!CheckEntry" End Sub "Niek Otten" wrote: Hi Michelle, Range("A3")=Date() -- Kind Regards, Niek Otten Microsoft MVP - Excel "Michelle Tucker" wrote in message ... I am creating a macro which will insert a row, then insert text in the first two cells. In the 3rd cell I want it to insert todays date. But if I use the TODAY function, the date will change all the time. Is there another function that will just insert todays date, but not change? -- Michelle Tucker |
I'm sure by now this question has been resolved for Michael, so this is for
the next guy or gal. Note that the Macro names are mine and yours will look different. Good luck. Chris Sub Macro3() ' ' Macro3 Macro ' Macro recorded Your Date< by Your Name< ' ' Keyboard Shortcut: Your Choice< ' Range("A3").Select ActiveCell.FormulaR1C1 = "=TODAY()" Range("A3") = Date Application.Run "'Your Book Name'!CheckEntry" End Sub "Niek Otten" wrote: Hi Michelle, Range("A3")=Date() -- Kind Regards, Niek Otten Microsoft MVP - Excel "Michelle Tucker" wrote in message ... I am creating a macro which will insert a row, then insert text in the first two cells. In the 3rd cell I want it to insert todays date. But if I use the TODAY function, the date will change all the time. Is there another function that will just insert todays date, but not change? -- Michelle Tucker |
|
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com