Hello Leith,
I'm also fairly new to VBA programming, but I'm attempting to create a similar solution that will delete blank columns across all worksheets building on what you provided to ncalsurfer. Obviously this is more difficult than I expected. Here's what I've got so far:
Your assistance would be greatly appreciated. I'm using Excel 2007, but also have access to Excel 2010 if needed.
Please Login or Register to view this content.
Last edited by Leith Ross; 11-27-2015 at 02:53 PM. Reason: Added Code Tags
Hello jrags01,
Welcome to the Forum!
As a new member, please read the Forum's Rules for posting when you have time. Forum Rules
Do any of the worksheets have merged cells?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
No merged cells.
Hello jrags01,
Sorry to be picky, do you want to delete columns that might have cells with just spaces in them?
Hi Leith,
My source data should not have any spaces in the cells as it has come from GIS. So I would like to delete all columns that don't have any data below the header row. If there is no data, delete the entire column.
Hello jrags01,
This will start with cell "A1" on the ActiveSheet. You can change this to were you data starts. The macro will find the last row and column with data or a formula in it. The first row of the range is assumed to be the header row. All columns that are empty within the range are deleted.
Please Login or Register to view this content.
Hi Leith,
That has worked brilliantly on a sheet by sheet basis so thanks for that. I wonder if there's a way to take it one step further and have it loop through all the sheets in the workbook and remove the empty columns, such that the macro would only have to be run once per file?
Thanks again,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks