The use of arrays

Hi Bart
Thanks for coming back, ....yep all good learning stuff

Originally Posted by CostCare

.....: before i used arrays i tried the .SpecialCells(xlCellTypeVisible) trick after i set an autofilter on the column through which i wanted to loop. This also increased the calculation speed, but from 6 to 7 seconds to like 4 or 5 seconds.......Arrays just did the trick for me! :-)....

...I always wondered why my code of that type always seemed to work the same without the .SpecialCells(xlCellTypeVisible) bit. So now I know that is just a trick to get it a bit faster, but which as you say is hardly noticeable compared to the speed advantages of going over to Array methods..
Alan