IRR does not accept dates; XIRR does:

Selection.FormulaR1C1 = "=XIRR(R1C:R[-1]C,R1C1:R[-1]C1,0.1)"

--
Regards,
Tom Ogilvy



Forrest wrote in message
...
I currently have an Access module that drops data into Excel and places
the cursor below the last row of the last column. I want to programically
place Excel's IRR function in this cell. Column A contains the dates and
column C the amount field. Code snippet:

' Selects c7; first blank cell at the bottom of a contiguous column
xlWs.Range("c1").End(xlDown).Offset(1, 0).Select

Thanks,

Forrest