View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derrick Derrick is offline
external usenet poster
 
Posts: 133
Default conditionally hiding rows

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!