Hiding rows based on cell result

**BaldySlaphead** · 12-15-2006, 07:27 AM

Hi,

I'm sure this is probably quite elementary really, but I can't do it.

C7 in a particular worksheet takes a value from a list: 'Yes' or 'No'. If the value is 'Yes' I wish the entire Row 7 to be visible, if 'No' then hidden.

That's it!

Thanks in advance for your thoughts,

Baldy

**Carim** · 12-15-2006, 07:41 AM

Hi,

In which cell is the original choice of Yes No ... because it is this cell that the event macro has to monitor in order to hide or not your row 7 ...

HTH
Carim

**Carim** · 12-15-2006, 07:49 AM

Hi again,

Adjust the following to your situation ...

Please Login or Register  to view this content.

HTH
Carim

**BaldySlaphead** · 12-15-2006, 08:09 AM

Thanks for that - it's great!

How about if I wish to hide more than one consecutive row? Would that just require me to change the Target.Offset e.g., if I wanted to hid three rows, would I put (6, 3), (6,9) or something else?

Cheers,

Baldy

**Carim** · 12-15-2006, 08:13 AM

Please Login or Register  to view this content.

HTH
Carim

**BaldySlaphead** · 12-15-2006, 08:34 AM

Where 3,6 & 9 are just the relative distance from the target row, yes?

And - sorry to be a nuisance - if I need to have more than one of these things on the same worksheet, how do I do that? I tried pasting the thing and renaming the subroutine to Worksheet_Change2 and also changing the variable name target to target2, but no luck...

**Carim** · 12-15-2006, 09:04 AM

Yes ... the offset() function, to use your terminology, works with "relative distance" ....

You can have many worksheets events with different events ... but for a given event you can only have one of each ...
Solution : code all your requirements within that particular one ...

HTH
Carim