Delete Empty Columns

Each month I download data from several testers we have on our production floor. I do my normal data crunching but have to endure having to delete empty columns manually. I can have over 400 columns and about 20-30% are always empty. Sometimes the empty column is by itself and other times I can have 2-4 columns side-by-side with no data in them. I want to delete all columns which have no data. Thanks.

ajocius

Hi,

Following Richards suggestion. Here is a possible code

Please Login or Register  to view this content.

Thanks

@fredlo2010
I like your TurnExtrasOff/On way of doing it.

Would this not do it if we're looping anyway?
fredlo2010's code without the extra row.

Please Login or Register  to view this content.

Originally Posted by jolivanes

@fredlo2010
I like your TurnExtrasOff/On way of doing it.

Would this not do it if we're looping anyway?
fredlo2010's code without the extra row.

Please Login or Register  to view this content.

Thanks jolivanes,

I was just following Richard's suggestion literally. After reading your post I was thinking that we don't even need to loop.

Please Login or Register  to view this content.

Thanks