I have attached a file with two macros in the vbeditor
this may not be an ideal xl sheet but I got it from somebody else
the macro testthree works
but after removing autofilter
the macro testtwo does NOT work. this uses variable in criteria
in intermediate widow
?"""=*" & x & "*"""
this is in testtwo (using variable in the criteria)
and hit enter I get
this seems to agree with the criteria in testthree. still test two does not work
where do I do the mistake?