I assume you have a number of rows hidden? after all in a sheet you can't
show no rows can you?

something like

Private Sub ComboBox1_Change()
Range("A10:A20").EntireRow.Hidden = True
Range("A10").Resize(ComboBox1.Value).EntireRow.Hid den = False
End Sub

this uses the activex combobox, so the code should be on the sheet's code
page - to get there, right click the sheet tab & select View Code

"Maze" wrote:

All:

I have a number of options in a drop down list and based on the selection
(2, 3, 4 etc) need to unhide rows. So if user selects 4, need to unhide 4
rows, if they select 0, no rows should show. What's the best way to do this?
Thank you.