display date last used a macro

Hi Everyone,

I want to display the date (including time) I last used a certain macro. For example, I want to cell "E3" in "Sheet4" to display when I last used "MacroX". What should I add to MacroX to make this happen? Thanks!

Regards,

Edward

Please Login or Register  to view this content.

Hi Edward
adding the code:

Please Login or Register  to view this content.

will do it if your working with a single Excel file.

Otherwise you have to add the Filename:

Please Login or Register  to view this content.

Thanks for the help, I've tried adding the line to a macro, but I keep getting the error:

"Runtime error 9: subscript out of range"

Before adding the following line, the macro worked perfectly:
'Copy date to certain cell in certain sheet to know when was last update
Worksheets("Sheet1").Range("E3").Value = Now()

What am I doing wrong? Thanks!

Please Login or Register  to view this content.