Hide row if cell is a certain value, with unhide toggle option

[stir-crazy]

Hi, I'm trying to configure a button in a worksheet to look at a range of data, and if the the value in the A column is "xxxxx" it will hide the entire row. Clicking this row again will display all of the rows again.

I have so far:

Please Login or Register  to view this content.

This almost works, except that if anything other than "xxxxx" is entered in a cell in the A column, it won't unhide.

When I try this:

Please Login or Register  to view this content.

I get the "Else without If" error. How can I get this to work? Can I not use two For Each... commands with a conditional hierarchy?

Please help! Thanks in advance.

[VBA Noob]

Please read forum rules and the message to cross posters below and then add the link to the cross post

VBA Noob

[solnajeff]

Hi

Perhaps the following code may be of use

Please Login or Register  to view this content.

Regards

Jeff

[stir-crazy]

Crosspost located at http://www.mrexcel.com/forum/showthr...=1#post1463763

Solved, finished code for those looking to do the same/similar:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.