ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to Delete empty columns (https://www.excelbanter.com/excel-programming/330738-macro-delete-empty-columns.html)

Darth Cor

Macro to Delete empty columns
 
I organize numerous excel charts with numerous columns. Each worksheet always
has a header row. I would like to know if anyone knows how to create a Macro
that will delete columns which contain a Header Row but no data?



Don Guillett[_4_]

Macro to Delete empty columns
 
how about a for/each loop looking for counta <2

--
Don Guillett
SalesAid Software

"Darth Cor" <Darth
wrote in message
...
I organize numerous excel charts with numerous columns. Each worksheet

always
has a header row. I would like to know if anyone knows how to create a

Macro
that will delete columns which contain a Header Row but no data?






All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com