ermccarthy
Board Regular
- Joined
- Feb 15, 2002
- Messages
- 224
I have a quick little loop that I wrote to search for a certain value in a cell, but I need a "second stop" Sometimes on this report, it the item was not used in a particular day, it will not show up, therefore, my loop would run forever with out stopping, I would like it to stop when it reachs row 1000. Here is what I have so far....
Do Until Left(ActiveCell, 3) = Range _("seg1").Value
ActiveCell.Offset(1, 0).Select
Loop
I am stumped!!
Do Until Left(ActiveCell, 3) = Range _("seg1").Value
ActiveCell.Offset(1, 0).Select
Loop
I am stumped!!