You would want a macro tied to a drop down or a change_event with a select
case imbedded.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Derrick" wrote in message
...
can anyone help me figure out this problem?
I have an drop down option list, and i would like to create an if
statement
that will hide select rows depending on which option is selected:
ie if option A is checked,
then rows 23,24, 26 are hidden.
if option b is checked,
rows 25, 27,28 are hidden
and if option c is checked
rows 21 22 29 are hidden.
simple enough i hope?

thanks!