I've simplified my last request and now need to know if there is a way to:
Use a worksheet containing 104 2 row entries and automatically find, select
individual rows that are blank, they will all be on the bottom, and delete
these blank rows finally showing only rows that have data included in them.
I also need to say the second row of the two won't have any data so when it
automatically finds the blank rows it will have to be by two.

i.e.
Row one at A would have text in it
Row 2 might have a number in it at P or Q
Both rows must remain together.

Thanks
Bob Reynolds