Problem with do..while..until..loop

[BeerKing]

Hello everyone. I hope I can get some help with this :o)

I have made a macro that looks like this(It's a macro for accounting):

Please Login or Register  to view this content.

This is just an extract of the full macro, but it should be enough for me to explain.

As you can see of the selected range, the worksheet wil now probably have the words Rent, Food and Insurance in cells B4, B5 and B6, and there is a number in cells D4, D5 and D6 which is being copied to a column farther to the right. So far the macro works. The problem is, if I then enter Rent, Food and Insurance again in cells B7, B8 and B9, and some numbers in cells D7, D8 and D9, the macro totally ignores this, and I've tried several times with do..while.until..loop, but it just doesn't work.

Does anyone have a clue??

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You are exiting the For Loops as soon as you find the first cell that meets the IF test.

I would imagine you want to procress all the cells in the range so something more like this.

Please Login or Register  to view this content.

[Charlize]

Variation on this theme :

Please Login or Register  to view this content.

Charlize