Fred,

The heading is in C19 and the yes/no box is in G19 - if G19 is "no" then I
need to hide row 20. It would then go to C21 and if the answer in G21 was
"no" I would need to hide rows 22-25.

Regards
Anne

"Fred Smith" wrote:

You'll need to provide more details. Try providing specific example, as in:

I have a heading in row 1. In cell c1, there is "yes" or "no". If c1 is "no", I
need to hide row 2.

Given this kind of detail, you'll have no problem getting someone to show you
the code required.

--
Regards,
Fred


"Anne" wrote in message
...
thank you, but I'm not sure how to explain it. I'll try:
1st row has a heading with yes/no answer in next column. Dependant upon the
answer is whether or not the next rows are applicable. If the answer is no
then the next wouldn't be applicable and need to be hidden to enable the
person to continue with the next question etc.

"Otto Moehrbach" wrote:

You would need VBA for that. Post back with more detail about what you have
and what rows you want hidden when what question gets a Yes/No. HTH Otto
"AP" wrote in message
...
I am trying to create a form wherby if the answer to say Q1 is no then I
need
to make the following rows in that section hidden