Hi guys,

I have a macro that merges and edits files from a folder. Part of the editing is that it will delete any blank rows if a cell in Column A is blank. It's worked fine till now as some of the files are not always populated and is inserted as a blank row.

However, I've now had the situation where all the files have data in them, so there are no blank cells. So when I run the code I get a debug error.

How can I adapt this code to check if there are blank cells in Column A and then delete the row? Or can I just use some error handling?

With Columns("A")
    
        .SpecialCells(xlCellTypeBlanks).EntireRow.Delete
        
End With