Hi Group,
I have some code to do a Match on a date, if the date is hard coded in the
formula it works just fine, but i am trying to get that date in via a
variable.

This works:
ActiveCell.FormulaR1C1 = "=MATCH(""1/25/99""+0,DateRange,-1)"
but his does not:
ActiveCell.FormulaR1C1 = "=MATCH(" & (Z1) & "+0,DateRange,-1)"
Z1 is the variable with the same date, but it fails to get the " " around
the date and fails.

The +0 is not being used currently, but is will be used to find an
appromiate date, later in the code, one year later. It is being used in a
table with about 5 years worth of data.

Thanks,

--
David