According to this link, For...Next is faster.

http://msdn2.microsoft.com/en-us/lib...ffice.10).aspx

I should have mentioned, this link is for VBA in Access, but one would think
the results should apply throughout the Office products.

Rick