Hide/show rows based on 2 drop down selections

M

Maritza

How do I add a second target Located in a drop down in D4?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("D7"), Target) Is Nothing Then
Range("A29:A47").EntireRow.Hidden = False

If Target.Value = "Refund" Then
Range("a29:a32,A39:A40").EntireRow.Hidden = True

ElseIf Target.Value = "Write off" Then
Range("a33:a46").EntireRow.Hidden = True

Else
Range("A29:a32,a41:a46").EntireRow.Hidden = True
End If

End If
End Sub

-- Thanks in advance!
Maritza
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide / show rows based on two drop down selectiosn 3
how to have 2 drop down lists filter rows 2
Excel 2007 macro does not work 1
when certain rows are hidden, can I also hide a combobox? 6
Separating sub procedures 4
Hide rows using VBA based on cell value 0
Unhide/hide based on drop down list 0
Hide Next row based on Cell Value 3

Top