which one is faster in excel vba, For loop or Do-While loop?

[nehanaik25]

Hi,

I am looking for an answer for which one is faster in excel vba, For loop or Do-While loop?




Thanks in advance!

 

[pjmorris]

Not sure you still want an answer. But for what its worth my investigation would suggest that the FOR loop is quicker by about 20%.