Thanks P45.

I've tested the code and it seems to runs fine. And it's shorter as well so great stuff.

Paul - Wildcard search sounds awesome but trying to think in what circumstances other than not knowing the exact names of the columns I want to delete, would it be useful. Did you mean in this context or something else?

Thanks

Master but not of VBA