Is there a way I can display in a cell the time a macro was last run? Any help is appreciated! Josh
J Josh Craig May 8, 2009 #1 Is there a way I can display in a cell the time a macro was last run? Any help is appreciated! Josh
F FSt1 May 8, 2009 #2 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
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
J Jacob Skaria May 8, 2009 #3 Why dont you write a timestamp to a cell at the end of the macro.. If this post helps click Yes
J Jacob Skaria May 8, 2009 #4 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
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
