Hiding Rows Using IF Statement

L

Larry Fitch

I would like to be able to hide a number of rows based on the response to a
question..

The response to the question is a list box with either "yes" or "no" as the
choices.. If the response = "no" then I would like to hide the next 3 rows,
otherwise do nothing..

Is there a "hide" command of some sort that I can use as part of an IF
statement or will I have to use a macro?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hisind rows with an if statement 1
hiding rows with an if statement 1
Page numbering with Merged Document and IF statements 1
Hiding rows 1
How to write a macro to hide an entire row 9
Automatically Combine Cell Contents and Delete Rows 0
using a value in a cell to hide rows 8
Code to add comments to selected cells within a selected range 30

Top