FormulaArray in Excel 2007
 

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

FormulaArray in Excel 2007
 

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

"Barb Reinhardt" wrote:

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