This is a snippet of code that is bothering me. I have Query Tables and Pivot Tables. I'm trying to refresh the query tables first, and then refresh the pivot tables because the pivot tables pull data from the query tables.
I keep receiving this error: "Run-Time Error 91: Object Variable or With Variable Not Set"
Debug points to the last line of this code snippet.
Any help is appreciated!
Please Login or Register to view this content.
-David
Last edited by dfaunce83; 03-09-2012 at 12:38 PM.
Thanks Rory!
It works great. I was wondering what the significance of the " (1) " was after ListObjects?
Thanks
-David
It refers to the first table on the sheet. I took a guess there was only one on each.
Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks