| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
display time when macro was last run
Is there a way I can display in a cell the time a macro was last run?
Any help is appreciated! Josh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display time when macro was last run
Why dont you write a timestamp to a cell at the end of the macro..
If this post helps click Yes --------------- Jacob Skaria "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
display time when macro was last run
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 --------------- Jacob Skaria "Jacob Skaria" wrote: Why dont you write a timestamp to a cell at the end of the macro.. If this post helps click Yes --------------- Jacob Skaria "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| programming a macro to display the current time | Excel Programming | |||
| Time display | Excel Discussion (Misc queries) | |||
| Time Display ? | Excel Worksheet Functions | |||
| Can you perform ctrl+shift+; in a macro to display time? | Excel Discussion (Misc queries) | |||
| Display one row at a time | New Users to Excel | |||
Linear Mode
