TODAY function?

M

Michelle Tucker

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?
 
N

Niek Otten

Hi Michelle,

Range("A3")=Date()

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
S

strazz

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
 
S

straz

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
 
S

straz

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
 
Top