Forum Discussion
Solved
Filter a column for a list of names with VBA
Hi everyone, I am trying to filter a column for a list of names on another sheet with VBA. The column that I am filtering in is not part of a table or pivot table and I am unable to change that, ...
BriceChapman Your "Criteria" array needs to be horizontal (in a single row). Try using Application.Transpose on the criteria range as follows:
Criteria = Application.Transpose(Worksheets("Deal Admin List").Range("F2:F19").Value)
BriceChapman Your "Criteria" array needs to be horizontal (in a single row). Try using Application.Transpose on the criteria range as follows:
Criteria = Application.Transpose(Worksheets("Deal Admin List").Range("F2:F19").Value)- This was it, thank you again djclements!
