This thread is for discussions of Make LBound() and UBound() even more efficient.

Really, doesn't  the VB Interpreter take care of this for you ?
I used to work on C++ compilers and the optimizer will create this substitution for you.

Just to confirm the previous poster, For loop variables are automatically record by the compiler on the first iteration.  

While and Do Loops are re-evaluated every time and will benefit from turning complex expressions or references into variables before starting the loop.

Cheers, Jon