Hi,
I have a code which produces a summary from another workbook. However, the summary is made of many formulaarray's to count items. So in order to use this i have set the ranges for the number of cells in a column. This is around 20.
I think this is slowing the code down, does anyone know of there is an alternative i can use? Below is a example of one of the formulas i use at the moment:-
Thanks
Blunder
I have a code which produces a summary from another workbook. However, the summary is made of many formulaarray's to count items. So in order to use this i have set the ranges for the number of cells in a column. This is around 20.
I think this is slowing the code down, does anyone know of there is an alternative i can use? Below is a example of one of the formulas i use at the moment:-
Code:
LR = wa.Range("a65536").End(xlUp).Row
Set rng = wa.Range("r2:" & "r" & LR)
strrng = rng.Address
Range("e" & s).FormulaArray = "=count(if('[" & wb1.Name & "]" & wa.Name & "'!" & strrng & "<>""MATCHED"",0))"Thanks
Blunder
