Excel VBA variable name in autofilter criteria 1

[Hcleslie]

I have a string variable Manager_Val that I would like to use in autofilter criteria

.Range("A1").AutoFilter Field:=2, Criteria1:="<>(Manager_Val)"

When I run the macro I am getting the actual name “Manager_Val”, instead of the value of the variable.

How do I refer to the variable Manager_Val for criteria1?

Thanks

 

[SkipVought]

Hi.

.Range("A1").AutoFilter Field:=2, Criteria1:="<>" & [Manager_Val]

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]