display time when macro was last run

  • Thread starter Thread starter Josh Craig
  • Start date Start date
J

Josh Craig

Is there a way I can display in a cell the time a macro was last run?

Any help is appreciated!

Josh
 
hi
this should do it.
Range("A1").Value = "Last run"
Range("A2").Value = Time ' or Now or Date
stick this line at the begining or end of the macro or anywhere you think is
good
adjust ranges to suit.

Regards
FSt1
 
Why dont you write a timestamp to a cell at the end of the macro..


If this post helps click Yes
 
Sub MyMacro()
'Timestamp
Worksheets("Macro Log").Range("A1") = "MyMacro"
Worksheets("Macro Log").Range("B1") = Now()
'/Timestamp

< your code>

End Sub

If this post helps click Yes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
VBA set thick borders around non empty cells in range 0
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksh 21
Macro to delete last entry of a column 5
Macro triggered by date 4
Pasting cell contents into a macro 1
Cannot display Add-in Macro list without going to VBA/Project 5
Verifying if new data has been added to excel file ? 4

Back
Top