end with loop question
WIll the following work correctly?
Dim rng as Range
set rng = Range(o2:M5)
DoThis: with rng
do something until the ActiveCell goes outside "rng"
ActiveCell.offset(1).select
goto DoThis
End With
Gets here when the ActiveCell is outside of "rng"
If not, please suggest a method to control execution while ActiveCell is
within a range.
TIA
Lee Hunter
|