Quote:
Originally Posted by Graham Griggs
every time I see .formulaArray I know it is going to be slow and unreliable, even if you get it working in the first place
|
It's not unreliable and nor is it any slower than it would be entering the formula yourself in Excel (in fact, it's quicker since you only have to type the formula once).
I also don't follow this comment:
Quote:
|
If you want to use it repeatedly then write it in Excel
|
since that's exactly what the code is doing - putting the formula into cells.