Hide/I hide rows by cel value

[Maxjay]

Hi can anyone help as I am new to VB

I am trying to hide rows by using a cell value, I have tried all sorts of codes but none work. Here's what I have and want to do:

I am using cell i18 which is a drop down box the values are "blank box", "Percentage","value"

I want to hide rows 19 and 20 if the cell is blank and have them show if either the word percentage or value is chosen.

Thanks for any help in advance

 

[SkipVought]

Hi,

Turn on the Auto Filter.

Filter to hide whatever rows you wish.