Hide & Unhide columns based on a cell value

Hello everyone,

I have a particular problem with a worksheet I am working on at the moment, basically if row 5 has a 0 displayed I want that column to hide, but if row 5 has text of any value displayed I want it to unhide, the range is E5 to BA5 across.

I have draft VBA code as follows:

Please Login or Register  to view this content.

This works to an extent in that it will hide the columns with the 0 displayed, but when I unhide them the word TRUE is input in other blank cells, and also if text is input for the hidden rows they do not unhide...

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Replace the Color Tags with Code Tags

Thanks for taking the time to read and comply with the rule .

Your question says the cell contains 0,but the code looks for "Hide Column"

If the cells contain zero then this should work

Please Login or Register  to view this content.

Note you do not restore calculation in your code

To change the code to unhide change to this line

Please Login or Register  to view this content.

You didn't mention that, try

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save