View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default display time when macro was last run

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

"Josh Craig" wrote:

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

Any help is appreciated!

Josh