Dropdown to hide/show rows

I have a cell that is using data validation using the numbers 1-15, based on the number in that box i want to show that number of rows, the default is 1 so lets say row will be visable, if the drop down changes to say 3, rows 3,4, and 5 will be visable. The closest i have gotten is autofilter but does not show the rows, just a row at a time. I dont want the dropdown to add rows, just hide/unhide them based on the dropdown number. Is this possible?

dont quite follow if in your example 15 was chosen do you want to show 1-15 or 15-29. cant see the logic of 3 show 3-5

Try this:

Please Login or Register  to view this content.

thankyou for your response,

Thankyou for the code, i tweaked a little bit, only issue is that with the number 2 being chosen it should show 2 rows but it only hows the same as if 1 were chosen.

Here is the code i am using from your example:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A2")) Is Nothing Then
Rows("4:17").Hidden = True
For i = 1 To Range("A2").Value
Rows(i + 1).Hidden = False
Next i
End If
End Sub

Correction: everything is offset by 1, if you select 1, nothing appears, if you select 2, one row appears, if you select 3, 2 rows appear, and so on

Can you please edit your post #5 above to wrap the code in [code] tags as per forum rules? Or just delete the code.

Thanks.

I know it looks like your question is related, but it's actually a completely different topic. Forum rules make posting add-on questions in someone else's thread a no-no...so remember that next time, OK.

Just start your own thread and include links to other threads you "think" might be relevant.

In this instance, your own question is simply: "Can you have more than one Worksheet_Change macro in one sheet?" If you Googled that question, you'd find immediately the answer is no.

But you can make the one ws_change event do multiple things.

Please Login or Register  to view this content.