≡ Menu

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

Excel Macro

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
Doctor Moxie

Written by -

NHS Accountant with geeky tendencies - serial blogger on subjects varying from Excel, Raspberry Pi, productivity, allotment gardening and running. The NHSExcel blog is reserved for Excel topics.

Comments on this entry are closed.