Hi Nigel

Sub DateMe()
Sheets(1).Range("C14").Value = Date
End Sub

HTH. best wishes Harald

"Nigel" <[email protected]> skrev i melding
news:[email protected]...
> Hi All
> I have a requirement to, from within VBA, store the
> current date into a worksheet.cell. But for that date to
> be non-volatile.
>
> If I use the system date functions then this will always
> change, after the worksheet is reloaded. What is the best
> approach to overcome this?
>
> Cheers
> Nigel