VBA Code For AutoFilter

Hope someone can correct the syntax for me.

I am creating a text string in VBA that looks like

fltrtech = "Joe", "Tom", "Bill"

and then trying to filter a worksheet with

HTML Code: 

The list of names are in column X which is 20th column from E.

If I insert the exact text string in the above command line [in place of variable "fltrtech"] then it works.
But in my case this text string will change so I need to be able to use a variable.

Thanks in advance for your help.

modytrane

Suggest you post all your code and a sample workbook with some typical data so that it can be tested.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I got it to work after doing some research.
If it helps someone else, I realized that following code works if the variable "fltrtech" is an Array [not just a text string].

HTML Code: 

I really appreciate help from all the experts on this forum.

You're welcome.


Thanks for sharing your solution.