Runtime Error 9 with List Objects

[kelseygueldalewis]

I am trying to create a automatic filter with listobjects in excel VBA but it is giving me a runtime error 9. I have checked to make sure that all of the sheet names and table names match but I can't figure it out.

Error is thrown on this line

Set lo = qws.ListObjects("filter")

Please Login or Register  to view this content.

[Norie]

In the uploaded workbook there are no listobjects on the sheet PQuery, filter refers to a named range on that sheet.

[kelseygueldalewis]

The data in my actual workook (can't share because has sensitive data) with the tab titled PQuery comes from a Power Query. How can I refer to this data as a listobject?

[Norie]

If you are sure it's a listobject, and I'm not 100% sure it will be, you could try using ListObjects(1).

[kelseygueldalewis]

That worked perfectly! Thanks!