Deleting worksheet rows based on if the first column cell is empty

Good Afternoon!

I copied over two columns of data from a larger spreadsheet and pasted them to a temporary worksheet starting at ("B3") on the temporary.

As the second column ("C") is always populated with some value I use it to determine the last row of a range that varies from one run to another.

Before processing any further I need to eliminate any row on the temporary sheet in which the cell in the first column ("B") is empty.

wsCH has been Set to the temporary worksheet.

Is there a more efficient way to accomplish this than the following?

Please Login or Register  to view this content.

I am asking for even with just 100 original rows of data this part of the routine consumes the greatest amount of time-

Thank-you for your thoughts!

.
This deletes 1,000 blank rows in under 1 second.

Please Login or Register  to view this content.

Thank-you; interesting approach. Going to give it a timed try!

.
How long does it take with your code ? How many blank rows ?

.
bakerman's code is elegant and clean.

I am now wondering how many other times I have wasted time on loops when something like that could have been used...

Great thanks for the help!!!