How to set a loop around a script?

[Paul_Hossler]

With the Select Case statement, let's say the value is 500, isn't the first Case going to be executed (Is >= 50.3778337531486) rather than the 6th Case, and the rest of the cases just jumped over? Is that the intention? Or should all those >= be < with another tweak or two? (Or perhaps keep the greater-or-equal-to and reverse the order of the Cases) I've not tested this! (no Excel right now)

I think you're correct

all the Case clauses should be <=

I also forgot to turn off screen updating

Normally, I'd have put all the values into a little WS list and Matched from that without all the Select Case