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

just range("a3")=date will do it

--
Don Guillett
SalesAid Software

"strazz" wrote in message
...
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