+ Reply to Thread
Results 1 to 3 of 3

QueryTable Error

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    QueryTable Error

    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.

    Please Login or Register  to view this content.
    Any help is appreciated!

    -David
    Last edited by dfaunce83; 03-09-2012 at 12:38 PM.

  2. #2
    Registered User
    Join Date
    02-20-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: QueryTable Error

    Thanks Rory!

    It works great. I was wondering what the significance of the " (1) " was after ListObjects?

    Thanks

    -David

  3. #3
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: QueryTable Error

    It refers to the first table on the sheet. I took a guess there was only one on each.
    Good luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1