Keep a date from updating

[mellowe]

Hi there. When I run my macro it populates cell A1 with todays date,
the problem is the next day the date changes to the current day. I
would like the date to stay at the date the macro is run then the next
day it keeps the date etc. so I can look back in the month and see the
correct date. Please help , am I missing soemthing simple here?

 

[Bernard Liengme]

Convert the formula [I expect it is =TODAY() ] to a value within the macro
with
these three lines of code
Range("A1").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

best wishes

 

[mellowe]

Thanks, but how do I incorporate this into my formula which is:

Range("A1").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("A1").Select
Selection.NumberFormat = "[$-F800]dddd, mmmm dd, yyyy"

 

[Niek Otten]

Range("A1") = Date
Range("A1").Numberformat =...................

You don't have to select, and VBA knows the date as well, so you don't need
TODAY()

 

[mellowe]

Thankyou very much this seems to do the job, I will be testing for next
few days.