Button to show/Hide rows not working

**ramatthews** · 05-09-2015, 03:29 AM

Can Anyone please help me? I am struggling with the code for a button to show/hie specific rows:

Please Login or Register  to view this content.

Let us assume Cell "I2" can be two different variables. The two variables is "Large enterprise" and "Qualifying Small Enterprise". When cell I2 is "large", then the code should hide rows 160:178, hide rows 5:151 but show 180:194. Therefore, when it is clicked again, it only shows rows 5:151, but hides rows 160:194. When cell I2 is "Qualifying Small Enterprise" then it needs to swap around when the button is clicked i.e. 180:194 is shown, and 160:178 is hidden, with the other features staying the same. The "Qualifying Small Enterprise" part does not want to work. It does not show row 5:151 when the button is clicked again after it has shows row 180:194. I have attached the sheet for your attention. can anyone please help, as I do not know what I am doing wrong.

**PCI** · 05-09-2015, 04:28 AM

I would suggest to use (NOT TESTED, some issue to doawload the file)

Please Login or Register  to view this content.

**ramatthews** · 05-09-2015, 04:50 AM

Thank you for the suggestion, however rows 180:194 does not want to hide if I click the button again. I have attached the file again for your information. I don't know what I am doing wrong. Need to inform you that I am very new to VBA. Thank you sooo much for the assistance already. My code look as follows:

Please Login or Register  to view this content.

**PCI** · 05-09-2015, 04:56 AM

I would suggest to go step by step.
Select all rows and unhide
Go to the macro and put a breakpoint: select the first statement and press F9 in the left margin
Launch the macro and use F8 and see what's happen