Macro to Insert a “Last Update On:” Date Value

I have a number of summary reports that are updated by the use of a macro update button.

I usually include an area on the report to include a datestamp that indicates when the report was last updated or refreshed.

This is the code I use:

1
2
3
Dim VERSIONDATE As String
VERSIONDATE = Format(Now, "dd-mm-yy hh-mm-ss")
Range("B3").Value = VERSIONDATE