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 colum
xlWs.Range("c1").End(xlDown).Offset(1, 0).Selec

Thanks

Forrest