VBA: Filter range by dropdown list selection + another criteria

[Martin_H]

Morning all,

I hope you all had a great weekend.

This newly created thread follows this one.

I wanted to filter the range D4:D590 by value selected from dropdown list located at the cell DK1, which has been solved by Fluff and fadee2. I used this code for it:

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "DK1" Then
      Range("D4:D590").AutoFilter 1, Target.Value
   End If
End Sub

Now, I would like to add one more criteria.

So basically when I select a value from dropdown list located at cell DK1 it will filter range D4:D590 based on DK1 cell selection and I would like to hide all zero and blank values in the range DO4:DO590 with it.

Thank you.

 

[Fluff]

Did you get rid of the existing filter?

 

[Martin_H]

Yeah, I have removed them all. There is no filter right now. Problem still occurs.

 

[Fluff]

Do you have data all the way from col D to col DO?
Is your data in a structured table or just a normal range?
Is the sheet protected?

 

[Martin_H]

So, I have changed 112 to 116 in the code and it is working perfectly now.

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[Martin_H]

Once again, thank you Fluff