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.
In the uploaded workbook there are no listobjects on the sheet PQuery, filter refers to a named range on that sheet.
If posting code please use code tags, see here.
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?
If you are sure it's a listobject, and I'm not 100% sure it will be, you could try using ListObjects(1).
That worked perfectly! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks