Excel - Conditional Hiding of Rows

[AlsGal52]

First, our company uses Office 2000.

I want to create a form that managers have to fill out that has approximately 75 questions. Depending on what employee level the associate is (answer entered in cell B9) determines which questions the manager wants to show up in the rows below in which they have to answer. This means, if the employee level is 20, the manager only wants to see Questions 1-10, 17-25, and 45-57 to show below which makes it easier for them to answer only questions that apply to employee level 20. All other rows need to be hidden.

Is there a way to do this?

 

[combo]

Tis is one of possible solutions:

[tt]Dim QuestionRanges(1 To 20) As Range
With Worksheets(1)
Set QuestionRanges(1) = Union(.Range("A2:A3&quot, .Range("A7&quot)
Set QuestionRanges(2) = .Range("A2:A3&quot
End With
' ...
Worksheets(1).Rows.Hidden = False
QuestionRanges(1).EntireRow.Hidden = True
MsgBox "Rows of first range are hidden"
Worksheets(1).Rows.Hidden = False[/tt]

combo