Loop stop at first hit?

[Bundi999]

Dear experts,

I have a loop on my vba code and it does not work; it only shows one value.

Purpose of the code:

For every "TRUE" in column C (3) for the rows 3 to 33 I want the code to copy the value of cell in colum B (2) for the rows 3 to 33 and paste them in the first empty cell under column ZZ. So when the loop works all the columns should be under eachother in column ZZ. However when I run this code it will only give me the 1 single value which is the last one in the entire data sheet that has TRUE indeed. So I guess my loop has an error.

Can you please advise?

Thanks you!

B

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[alansidman]

Move your line for next row to just below your j = 3 to last row.

It is continually overwriting your next row variable and not incrementing it.

To be sure of this, run a debug on your existing code Step into the Code by using F8 and see what happens with each line.

[Bundi999]

Dear Alansidman,

Thank you so much for helping me out on this one, it works perfectly now. Next time I will check the forum rules first, thanks a lot for making the adjustments. I very much appreciate your help!

Thanks!

[alansidman]

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.