Lidder
09-16-2014, 11:48 PM
Hi,
I have the following problem:
I am using .AutoFilter in my code and the Criteria1 is taken from the UserForm, so it is given as a variable. I would like to modify the code to make it bulletproof. :) Now the code is like:
Criteria1:=A, where A is a variable. I would like to create something like:
Criteria1:=*A*, where A is still a variable. Since I can't use
"=*A*", what are my options here?
Cheers,
L.
I have the following problem:
I am using .AutoFilter in my code and the Criteria1 is taken from the UserForm, so it is given as a variable. I would like to modify the code to make it bulletproof. :) Now the code is like:
Criteria1:=A, where A is a variable. I would like to create something like:
Criteria1:=*A*, where A is still a variable. Since I can't use
"=*A*", what are my options here?
Cheers,
L.