Goto Blank COLUMNS not all blank CELLS

Hello,

I'm trying to programmatically select blank columns but cannot use the edit>goto>blanks function as some of the columns contain blank cells.

I want to select the blank columns and delete them.

Please see the attached book.

Any ideas?

Thanks,

Chris

Originally Posted by chrismann85

Hello,

I'm trying to programmatically select blank columns but cannot use the edit>goto>blanks function as some of the columns contain blank cells.

I want to select the blank columns and delete them.

Please see the attached book.

Any ideas?

Thanks,

Chris

Hi Chris,
Check this out
http://www.exceltip.com/st/Delete_ro...Excel/482.html