[RESOLVED] This isnt working all of a sudden

ActiveSheet.UsedRange.Columns(3). _
SpecialCells(xlCellTypeBlanks).EntireRow.Delete

I have been using this for a while now to remove empty rows from crystal report that have been exported to excel. Today the report was altered so I needed to alter my code and now that above line deletes everything.

Anyideas?

To be honest I never use the UsedRange Property anymore because it doesn't seem very reliable.

How was your report altered?

Is the third row of your used range all empty cells?

I used to use column 2, now I have to use column 3. There is definately data in the column, but for some reason usedrange doesnt seem to recognize it.

If anyone knows a better way to delete blank rows I would appreciate it.

I googled to make sure, and found that an error exists if you delete a colum. Hope it helps

http://support.microsoft.com/default...NoWebContent=1

Thanks, I will try to modify that for the empty cells.

Just in case, any other suggestions?