View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee Hunter Lee Hunter is offline
external usenet poster
 
Posts: 17
Default 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