vba code needed:
I'm trying to delete empty or blank rows.
Here is the weird thing.
I'm copying and pasting data into this worksheet.
so a cell may contain some blank stuff.
but the row appears to be blank....
this will not delete those rows
I was gonna try and say delete any blank rows outside my usedrange, but afraid it would leave those rows..?
For x = wb.Sheets("Import Sheet").Cells.SpecialCells(xlCellTypeLastCell).Row To 1 Step -1
If WorksheetFunction.CountA(wb.Sheets("Import Sheet").Rows(x)) = 0 Then