Hi

I'm trying to assign the above date to FormulaR1C1 and it's throwing an
error. Later dates are fine. What's the best way to handle this scenario?

Thanks

Simon

This worked:

Sub junkthis()
Worksheets("Sheet1").Range("B1").FormulaR1C1 = "16/02/1871"
End Sub

BUt notice the "date" is in quotes. Remember that Excel can not handle true
dates prior to 1 January 1900.
--
Gary's Student


"Simon Woods" wrote:

Hi

I'm trying to assign the above date to FormulaR1C1 and it's throwing an
error. Later dates are fine. What's the best way to handle this scenario?

Thanks

Simon