Delete Blank rows

Hi,

i have some data and in between having blank rows. i want to delete all rows till my last row with data by having loop through each cell and validating with isempty formula, or any other criteria.

Thanks
Raju

Do you have a worksheet to post. There are several things to know. For instance is there a range of cells in a row that have to be blank before you want to delete the row, perhaps columns 1 through 9 etc.? Is it just one cell for instance if any cell in column A of a row is empty then delete the entire row?

Hi,

See attached file. i want the macro code to go through each row in column A until last row with text and delete entire row which are all blanks

Thanks
Raju

Hi,

I have tried this code given.

For x = Me.UsedRange.Rows.Count To 2 Step -1
If Range("a" & x) = "" Then
Rows(x).Delete
End If
Next

but i am getting an error, highlightinhg me.usedrange error.