Deleting blank columns/macro

Hi,

I'm looking for a macro where it will delete all blank columns. I have to dump a lot of raw data in an excel file and sort it but it's taking absolutely ages to select each column and delete it, I'm looking for a quick fix.

Over to you boffins!

Thanks,
Lew

Can you attach a small sample workbook and explain what you need.

I can but the raw data isn't standard so it's not something that I could record a macro to do as the empty columns change, I'm just looking for a piece of code that could, for example, look at the whole sheet and remove every column that has no data in any cells in columns.

Perfect, that's going to help me out a lot.

Thank you
Lew