Autofilter from data validation list

[Godders199]

Good Afternoon, I am trying to write up a code , find rows in the cases available sheet which match the value in cell c23 on the instructions tab

C23 is a Data Validation list of names, so which ever name is selected, that is the name i want cases available tab to be filtered by. As I have not tried to filter from a data validation list before i wanted to make sure this element works before i move on. Unfortunately the code below errors saying Autofilter method of range class failed.

Can any one point me in the right direction please.

thanks


Sub Source_cases()
Sheets("cases available ").Select
Selection.AutoFilter
ActiveSheet.Range("A:T").AutoFilter Field:=7, Criteria1:=Sheets("Instructions").Range("C23").Value

End Sub

 

[Ken Cowen]

I think this should work

Sheets("cases available ").Columns("A:T").AutoFilter Field:=7, Criteria1:=Sheets("Instructions").Range("C23").Value

I hope this helps./

Ken

 

[Godders199]

Thanks Ken, I had worked out the problem was the worksheet was in table format removing that sorted my problem.

I think this should work

Sheets("cases available ").Columns("A:T").AutoFilter Field:=7, Criteria1:=Sheets("Instructions").Range("C23").Value

I hope this helps./

Ken