Delete Empty Excel columns (after label rows) |
Post Reply |
Author | |
Crystal Long
Microsoft MVP Joined: 21 May 2012 Location: Colorado Status: Offline Points: 35 |
Post Options
Thanks(0)
Posted: 05 May 2016 at 9:41am |
Delete Columns in Excel that are Empty
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.
|
|
Warm Regards,
Crystal Microsoft MVP Remote Training & Programming Let's Connect and Build Together http://www.AccessMVP.com/strive4peace http://YouTube.com/LearnAccessByCrystal ~have an awesome day ~ |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |