I've attached the .xlsm file with the code but it doesn't seem to be working. Is their something I can't see in the first column and how can I tell? Is the syntax in error?

I just want to run through my excel data file removing all blank first columns.

Thanks!test.xlsm