VBA data clean up

[kgkev]

Hi,

I am trying to create a CSV file for upload and need to clean a little bit of data.
I am struggling with one bit. If any cell in column "B" is blank then the entire row should be deleted....

.Columns("B:B").SpecialCells(xlCellTypeBlanks).EntireRow.Delete

worked a treat in my dummy runs, but on the live document all columns start at formulas and are copy and pasted as values to a new book.
So the first 200 rows look blank, but aren't

is there a simple way to resolve this or do I need to step through each row and delete one my one?

 

[rlv01]

but on the live document all columns start at formulas and are copy and pasted as values to a new book

Do the row deletion in the new workbook.