macro with F9
 

I want to a macro to insert the formula =TODAY() and then recalc it to make
it a static result that represents the date as of the time the macro is run,
not a dynamic formula that would change with each new day. I have recorded a
macro to do this. If I run the macro & today is Aug 3, the correct result
would be 08/03/2005, not the formula =TODAY(). However, if I run my macro
tomorrow, Aug 4, the macro returns a result of 08/03/2005, because the code
that resulted from my macro-record has a line in it, such as Select Active
Cell. Active Cell = "08/03/2005." I would like the macro to execute the
recalc function, not return a value that was the result when the macro was
first recorded. Would appreciate any help. Thanks.

hi,
add this your your macro

Activecell.Value = Date

regards
FSt1

"Kenny" wrote:

I want to a macro to insert the formula =TODAY() and then recalc it to make
it a static result that represents the date as of the time the macro is run,
not a dynamic formula that would change with each new day. I have recorded a
macro to do this. If I run the macro & today is Aug 3, the correct result
would be 08/03/2005, not the formula =TODAY(). However, if I run my macro
tomorrow, Aug 4, the macro returns a result of 08/03/2005, because the code
that resulted from my macro-record has a line in it, such as Select Active
Cell. Active Cell = "08/03/2005." I would like the macro to execute the
recalc function, not return a value that was the result when the macro was
first recorded. Would appreciate any help. Thanks.