for loop listing without empty cells

[peterschein]

Dear Pros,


Can anyone help me pointing to the mistake in my code?


I want to list the entries from sheet 2 to sheet 1 without any empty cells in between them.

If i run the Code as it is, it keeps listing just the last entry.
If I update lastrow2 it keeps listing all the entries but with empty cells between them..


Can anyone modify it to work properly? (with as litte Change as possible to be able to see what I was doing wrong)


Thank you indeed for your help!


Best regards
Peter

[NeedForExcel]

Hi,

Try this out

Please Login or Register  to view this content.

[peterschein]

Thank you for your answer NeedForExcel

I am not that far with Arrays..and I will Need to adopt it to other Sheets. Can you Maybe tell me how to alter my existing Code?

I know it is not that elegant or Fancy as yours

thank you indeed!

[Akuini]

Can anyone modify it to work properly? (with as litte Change as possible to be able to see what I was doing wrong)

Please Login or Register  to view this content.

[NeedForExcel]

I am not that far with Arrays..and I will Need to adopt it to other Sheets. Can you Maybe tell me how to alter my existing Code?

You can try out the code given by Akuini, that should serve the purpose..

[peterschein]

end if…

thank you!!!

[peterschein]

Dear NeedForExcel Dear Akuini


If I apply it to the final Code I get a warning that there is an end if without the if bock... do you know why?

if I comment the "End If" out, I got the list but with gaps in between..

can you help?

Please Login or Register  to view this content.

[BMV]

In the case of only constant in the source

Please Login or Register  to view this content.

[Akuini]

Try:

Please Login or Register  to view this content.

[peterschein]

Try:

Please Login or Register  to view this content.

wow I didn´t know that it makes any difference how I brake the lines.


but it works!

thank you!!

[Akuini]

You're welcome, glad to help, & thanks for the feedback.