|
Tag Browser: array-formula
< 1 second(s)
-
I'm having a problem using SetFormulaArray. Here is a snippet from the code i'm using:
f = String.Format(''=AVERAGE(IF(({0}:{1}=''''{2}'''')*({3}:{4}>0),{3}:{4}))'', _ ws.Cells(itemRow(1) + i - 1, colROWHEADING).Name, _ ws.Cells(itemRow(UBound(itemRow)) + i - ...
|
Live Chat