Yes, that is possible but you would need to furnish info on all the ranges.
HTH Otto
"Jason" wrote in message
...
I need help creating a question sheet. I have a question follwed by a drop
down list for the answer. What I need to do is have the spreadsheet return
a
range of cells based on the answer from the drop down list. I could have
the
range of cells hiden or on a different worksheet until the option is
picked
from the crop down list. Is this possible?