Help creating a loop

[morangeman]

Hi there i have a code that only a certain part needs looping here is the code:

Please Login or Register  to view this content.

(Loop ends here!)


End Sub[/CODE]


I need the loop to continue until there is no more data in column b or until this cell is empty on the second to last line:

Please Login or Register  to view this content.

Thanks

[fredlo2010]

Hi,

can you include a copy of your workbook. it will be easier to debug. Also can you explain what your macro do?

Thanks

[morangeman]

i cant include it sorry but what it does is its taking data in blocks of 24 going down and moving it into one long continuous graph.

the code works fine i just need the second part of it to loop until it comes across no more data in column b

[morangeman]

here is an edit to the code:

Please Login or Register  to view this content.

as you can see i have copied the last part instead of a loop. that is the part to loop until no more data can be found on sheet "tabelle1"

[millz]

Maybe this

Please Login or Register  to view this content.

[morangeman]

That worked a charm!! Thank you very much!! If possible could you please elaborate on what tha final line actually is saying?

Please Login or Register  to view this content.

[millz]

It's checking whether pressing Ctrl + down arrow from the activecell goes to the last row of the worksheet. If it does, meaning there are no more data below, at least not for that particular column.

[morangeman]

Thank you so much A+++++++++!