VBA code hide/uhide rows

[EmiliaClaire]

Hi,


I have a drop down list in a cell F4. My table is in cells A9:H39, and a column corresponding to drop down list is H (H9:H39) Depending on a choice from a drop down list, some of the cells in column H would show N/A. Upon a different choice from a drop down list, different cells would display N/A. And I would need for the whole row (set of rows) to hide/unhide depending on whether there's a N/A in that "H" cell.

Can anyone help?

[Fluff13]

Is the dropdown a data validation dropdown?
Also are the values in col H #N/A or just N/A

[EmiliaClaire]

No,It's just a regular drop down.
Cells filter drop down list and return a value with VLOOKUP and IF formulas; and it's just N/A

[Fluff13]

Not sure I understand what you're saying, could you supply a sample workbook?

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[EmiliaClaire]

Did it work?

The sample file should be attached now.

[Fluff13]

Thanks for that, how about

Please Login or Register  to view this content.

This needs to go in the Tab3 module