| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to set the FormulaArray property in Excel 97 | Excel Programming | |||
| Re : Excel FormulaArray Copy-and-Paste via VBA | Excel Discussion (Misc queries) | |||
| Using FormulaArray in VBA | Excel Programming | |||
| FormulaArray | Excel Worksheet Functions | |||
| FormulaArray | Excel Programming | |||
Linear Mode
