loading today's date into a cell from a macro

[jartzh]

I need to load the date the macro was executed into a cell.
When I load the cell with =today() then it puts the function =today() in the cell. Which of course always shows today's date.

How do I get it to put the value of =today() in the cell?

[shg]

Please Login or Register  to view this content.

[Shijesh Kumar]

code to add date thro macros

Please Login or Register  to view this content.

[jartzh]

SHG,
Thanks,
That did it.

[shg]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save