Automatically hide/unhide rows based on column A value

[c.bernardo]

Hello,

I have a worksheet with multiple pull-down lists in Col A. The pull downs change values of the cells below in Column A to either "Skip" or some other value. I am looking to hide the rows with "Skip" in Column A, as well as the one row below the cells with value "Skip". I've got this to work on another sheet with columns of horizontally oriented data, but have gotten stuck with the data oriented vertically (in one column). I've been able to get the rows to hide, but they will not unhide when the cell value is no longer "Skip".

Here's the code I've got running currently:

Please Login or Register  to view this content.

Here's a screen shot of my spreadsheet.

Screen shot.jpg

Thanks in advance.

[AlphaFrog]

If the dropdown is hidden because you set it to Skip, how do you then change the dropdron so it doesn't say Skip? If it's hidden, you wouldn't be able to select anything in the dropdown.

This does the same thing as your code. I don't know if it would solve your problem.

Please Login or Register  to view this content.

[c.bernardo]

Thank you for trying to help me AlphaFrog, I didn't do a good job explaining my worksheet. The sheet is a series of Questions with a pull-down in the next row below where the user selects an answer to the question. The first question answer can lead to future questions being rendered moot, and thus "Skip" will appear in lieu of the question. Since the question is moot, I am also looking to hide the associated pull down. So while rows may be hidden, selecting a new answer to the first question can change their value back to a question. This is where I am stuck, I can't get them to unhide. I also haven't figured out how to hide the pull downs.

Sorry for the confusion.

[AlphaFrog]

At the start of the macro, unhide all rows...
Rows("1:50").Hidden = False
and then have the code loop through and hide the Skip rows.

If you want to attach a workbook, I'll take a look.

[c.bernardo]

Thanks for all your help AlphaFrog, but I ended up transposing my data into row 1 and 2 to use code I already had working. I should've thought about this 15 hours ago. Here's what I'm running now and it's working.

Please Login or Register  to view this content.

Thanks again for your time.