Change selection of cells to selection of rows

Dear All,
while creating my macro, small push is needed. I have these - to select range.

Please Login or Register  to view this content.

In this range, I need to delete whole rows. On keyboard, Shift + spacebar and ctrl + minus.
How can I do the same in macro?

Task no. 2:
As you can see, I would like to delete it from first empty cell in B column, to B506 - in my template, here another part starts.
I need to delete afterwards part from first empty cells bellow B507 to B600. But - obviously, B600 will become sth else if I delete it. Any idea how to find it?


(in other words - I need to delete empty rows in sheet "rozpad" and its position should vary. I need last row in each selection will rest, for better visual view.
Rozpad - automat PV.xlsm)

Please Login or Register  to view this content.

Thank you very much both guys. Both ways are working as miracle. :-)

About task 2:
It seems I will be able to do it thanks to your help by myself.
Many thanks.

One more almost same question....
I found I can do it with autofilter meanwhile. Do you have any idea what is wrong in my code? I have copied it from some web...

Please Login or Register  to view this content.

Rozpad - automat PV v2.xlsm (last macro in module 2 named DeleteRowsBasedOnCriteria

Thanks again.

Just one thing to add, if the cells are completely blank (i.e. not containing a value or a formula) you could also use:

Please Login or Register  to view this content.

You are amazing. I almost have it, but... oh, I have a great date today - thanks. (btw: it works :-) )