Adapt code to delete row

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?

Please Login or Register  to view this content.

Thanks Domski. I am also very new to VB. I am learning from you people.