Delete Rows till next filled Cell

Hi everyone,

I'm new in this forum and I already got my first question for you! :)

I tried to write a macro which should delete rows starting at active cell, ending before next content cell in this column.

So for example if I have content in B2 (activeCell) and then again in B6, the macro should delete rows 2 - 5,
no matter which content is in other columns. Cells B3-B5 are blank!


Hopefully I wrote my issue not too confusing.
Please excuse the shitty english - I'm not a native speaker. ;)


Thanks in advance for your help & Cheers
Kaiserschmarrn

Welcome to the Forum. Try:

Please Login or Register  to view this content.

Oh great!
I also started with something like the first one, but for some reasons it deletes everything below the active cell.

Second one works fine!

Thank you so much!