Hide Columns IF Row 2 onwards is Blank

[Wheelie686]

The following code works..sorta. I can see that it's hiding the columns I want/are blank but then it immediately unhides them. What I want is when I press the button once, it hides them and then press it again, unhides them. Any idea where I went wrong?

Please Login or Register  to view this content.

[LokeshKumar]

Can you upload the workbook with this code for better understanding.

[Wheelie686]

Here you go! You can ignore the blue buttons (actually just shapes). They don't have code attached anymore. The grey toggle button is my issue, thanks!

[LokeshKumar]

Hi,

Can you check now it is working correctly?......Book1.xlsm

If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.

[Wheelie686]

not quite... for instance column C, E, I and K are blank whereas the others have a 1 in them. I only want the blank columns hidden.

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[LokeshKumar]

not quite... for instance column C, E, I and K are blank whereas the others have a 1 in them. I only want the blank columns hidden.

Hey sorry for bad explanation from my end. I was expecting you to be a familiar with VBA so I just removed the unnecessary part.
You can easily put the if else condition to check the blank.
If still face any issue pls let us know...........

[Wheelie686]

LokeshKumar, maybe it's me trying to be at work and mess with Excel at the same time but I just can't seem to get the coding right. I have some knowledge of VBA but I'm self taught through (mainly) this site and using the macro recorder. This is what I have so far. It hides the appropriate columns now but doesn't unhide anything.

Please Login or Register  to view this content.

[xladept]

Maybe:

Please Login or Register  to view this content.

[Wheelie686]

omg I forgot Else...literally forgot the word "Else". Thanks everyone... I guess I just needed to focus on what I'm doing.

Please Login or Register  to view this content.

Now to figure out why the button name doesn't work right...