=NOW() alternative?

2 worksheet open, one is macro coding and the other one is being coded.

How do I code date and time on another sheet. Alternative to code below.

Please Login or Register  to view this content.

You will have to replace the workbook and worksheet with the proper reference

Please Login or Register  to view this content.

I did. Neither one of these works.

Please Login or Register  to view this content.

Group is name of my workbook and the sheet

Originally Posted by stnkynts

You will have to replace the workbook and worksheet with the proper reference

Please Login or Register  to view this content.

by this code, when a user open it up it will show date of as now, I want to have it dated when it's updated.

Originally Posted by AlphaFrog

Change the sheet name to suit.

Sheets("Sheet2").Range("A2").FormulaR1C1 = "=NOW()"

1. MACRO.XLSM
2. GROUP.XLSM

coding on MACRO.XLSM to put todays date on cell A2 of GROUP.XLSM. Not put =NOW() on cell A2.
so when user open GROUP.XLMS next week, A2 will show dates of today.

yes I know.
I want to date the worksheet.
Right now, only thing I can think of is that =now() and save it as PDF, but I would really like to save it as XLSM.
I also save it's name to Group 1003.XLSM by using

Please Login or Register  to view this content.

Something like this?

Please Login or Register  to view this content.

ok, that worked. So use Date instead of Now.
Now, if I open the workbook tomorrow, A2 should be dated today 10/3 not 10/4 correct?

Either of these works

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

I was using

Please Login or Register  to view this content.

Thank you, that's ok it's working now.