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.
Can you upload the workbook with this code for better understanding.
Lokesh Kumar
Stay Hungry.. Stay Foolish..
_________________________________________________________
Please Click STAR to Add Reputation if my/someone's answer helped!
Here you go!
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.
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.
Maybe?
Please Login or Register to view this content.
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.Originally Posted by Wheelie686
You can easily put the if else condition to check the blank.
If still face any issue pls let us know...........
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.
Last edited by Wheelie686; 05-01-2015 at 04:56 PM.
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
omg I forgot Else...literally forgot the word "Else". Thanks everyone... I guess I just needed to focus on what I'm doing.
Now to figure out why the button name doesn't work right...Please Login or Register to view this content.
Last edited by Wheelie686; 05-01-2015 at 06:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks