Hi Guys,

I am new to VBA so may be somebody can help with my problem below:

I am trying to create a Macro that will Hide/Unhide certain number of Rows based on the value of certain Cells:

G15 to L15 can all have a value A,B or C (these can repeat themselves or can be blanks). In the current scenario G15 and H15 have values A and B and the remaining cells I15 to L15 are blank. I need a macro that will automatically hide and unhide the below rows once these values change.

CASE (A)
If Value A is present in any cell (G15 to L15) once or multiple times
Then Rows 125 to 146 are visible

CASE (B)
If Value B is Present in any cell (G15 to L15) once or multiple times
Then Rows 207 to 225 are visible

CASE(C)
If Value C is present in any cell (G15 to L15) once or multiple times
Then Rows 292 to 313 are Visible

So in above scenario since I have values A and B I would like to see ROWS in CASE (A) & CASE (B) but hide CASE(C). If in another scenario I change G15 to B and H15 to B and I15 to C then I want to see the RPWS associated with B and C at the same time hiding rows associated with A.

If every thing is blank in G15 to L15 then all associated rows need to be hidden.

Hopefully I have explained myself properly and one of you gurus can help me out.

Thanks