Need first statement to Loop until "False"

**bruce2444** · 07-27-2009, 01:14 PM

I have a worksheet built that obtains info from Sheet1(ACV) and enters it into Sheet2(Payment1), however when I run the process, only Line 10 fills and then it stops. I need to loop the first statement of the code, so that it fills all of column 1 until there is no info to fill then I assume the rest of the code will fill in the worksheet accordingly.

If anyone can help and tell me how I need to change this code, I'd appreciate it.

Here is the code I have now for Sheet2(Payment1), I have also attached the worksheet for reference.

Please Login or Register  to view this content.

**StephenR** · 07-27-2009, 03:14 PM

Not quite sure what you're doing, but see if this works for you. Place in a normal module (Insert > Module) rather than the sheet module. Why have you got two bits of code?

Please Login or Register  to view this content.

**bruce2444** · 07-28-2009, 12:15 PM

First and foremost thank you.

The code revision you provided does exactly what I was trying to accomplish with my minimal knowledge of VBA and my attempt to butcher together a code I had read here. It almost worked, but the way you wrote it is much cleaner and works seamlessly.