FormulaArray in Excel 2007

[Barb Reinhardt]

This used to work in Excel 2003, but now doesn't in Excel 2007. I'm sure
it's a setting somewhere, but am not sure where to look.

With myWS.Cells(lRow, 3)
.FormulaArray = _
"=MAX(IF('" & aWB.Name & "'!Function=RC[-2],IF(ISNUMBER('[" &
aWB.Name & "]" & myCurrWS.Name & "'!MonthYearAuditFinish),'[" &
aWB.Name & "]" & myCurrWS.Name & "'!Actual_Audit_Finish)))"
.NumberFormat = "m/d/yyyy"
End With


The problem seems to be somehow related to RC[-2].

Thanks,
Barb Reinhardt

 

[Barb Reinhardt]

I figured out my problem. It was related to Worksheet vs. Workbook level
named ranges.