My loop doesn't work why not

**ljh66** · 12-05-2007, 09:08 PM

My loop doesn't work. It has something to do with the placement of "do"

I am trying to repeat this function to the end of the data.

I also think the Range "b3", should be some kind of step down one.

I have Excel 2000 (gulp)

Please Login or Register  to view this content.

**johndough185** · 12-05-2007, 09:29 PM

I hope i'm not stating in the obvious, but if you copy/pasted there's an apostrophe before the "do" part of the loop...which would cause it to not be recognized. Other than that, I would check to make sure that you're moving the selected cell correctly. at the end of the loop you're selecting the same cell (B3), so if C3 is empty, it'll stop running every time after one run. I think you may want to put in an

ActiveCell.Offset(_,_)

before your "Loop Until" statement so that the selected cell actually changes and doesn't just keep being B3...naturally you'll have to take out the Range("B3").Select

**mudraker** · 12-06-2007, 02:04 AM

ljh66

Welcome to excelforum

Please read forum rules & wrap your VBA code

A thread with the rules is available at the top of each forum or see links below

If you do not understand the VBA code wrap instructions have a look at my last reply in this thread
http://www.excelforum.com/showthread.php?t=583950