I am trying to create a Macro to filter based upon the value of a specified cell. When I record a macro and then view the code the actual value that i have in the cell is being listed in the code vs. what the current value is in the specified cell. See code below. The example is where it says Cenvoe I though it should have Sheet3!B2
ActiveSheet.Range("$A$1:$AH$2126").AutoFilter Field:=5, Criteria1:= _
"=*Cenveo" * ", Operator:=xlAnd"