Delete Blank Columns only

[davidhall80]

I want to delete all blank columns. Is there a command that I can write into VB that will delete any columns that don't have any information in any of the rows. But it can't delete a column even if it only has one character in it. Only Blanks. Is this possible?

 

[daniels012]

Rows or Columns?

I want to delete all blank columns.

any columns that don't have any information in any of the rows

??

Michael

 

[daniels012]

Dependent on what you want, rows or columns,
An easy way to do this is to auto filter. Then put
blanks as your choice for the auto filter in each column.
Any rows that show up, delete them.

Michael