Delete Columns in Excel that are Empty
By Crystal Long
Use this code to delete columns that are completely empty by sending a parameter of one (1) for the first data row. The default is currently to assume there is a row of labels to skip in determining if there is data in the column.
This is also perfect to run from Access after writing the results of a query where you only want to see columns with information.
Download at: http://www.rogersaccesslibrary.com/forum/long-crystal_forum71.html