Delete or hide entire column if top cell is blank

**idowbush@gmail.com** · 09-09-2014, 11:53 AM

Hi I trying to make a macro that will check the top cell in a table (top cell is always in row 4) and hide the entire column if the cell is blank, then move to the next column and check if the top cells is blank, and hide that column if it is, and so on. The tables are usually less than 50 columns wide so would sufficient to just check the first 50 columns and end the macro.

Any help is welcome!

**sktneer** · 09-09-2014, 12:04 PM

Try this.....

Please Login or Register  to view this content.

**idowbush@gmail.com** · 09-09-2014, 12:53 PM

Thank you. I changed the code slightly to count the columns using row 6 be cause that row is guaranteed to have no blank cells and then it works perfectly.

Please Login or Register  to view this content.

**sktneer** · 09-09-2014, 12:59 PM

You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.