Thursday, May 5, 2016

Featured Sample: Delete Columns in Excel that are Empty

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

No comments: