Bernd,

It helped a lot. I used the Do While Loop and stopped it as soon as it
started decreasing! Thanks!

--
John - ThunderSnake #59
'69 Mach 1 w/ 390 4V
Wide Ratio Toploader
3.50 Traction-Lok
Acapulco Blue

wrote in message
ps.com...
Hi John,

You can tell the VBA debugger to stop when a variable will be given a
certain value.

You can estimate this value and enter it or you can store its old value
(of previous iteration), subtract this from the newer one and stop the
program if the difference becomes < zero (if your iteration is
monotonously increasing).

HTH,
Bernd