+ Reply to Thread
Results 1 to 2 of 2

Run Time Error "1004": A table cannot overlap another table

  1. #1
    Forum Contributor
    Join Date
    05-09-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    212

    Run Time Error "1004": A table cannot overlap another table

    Hi all,


    I am using the autofilter to filter the database as the coding showed below.

    Please Login or Register  to view this content.

    In the database, the number "1190" does not exist. Hence, the coding suppose is work and will paste a new original table on another worksheet. However, when i run the coding, error message is pop up showed "Run Time Error "1004":A table cannot overlap another table." and pointed to the command Sheets("Group_A").ListObjects.Add(xlSrcRange, Rng, , xlYes).Name = "_Table".

    I can't figure out the solution of this problem. Please help me.
    Thanks.

  2. #2
    Registered User
    Join Date
    02-05-2015
    Location
    Wilmington,NC
    MS-Off Ver
    2010
    Posts
    1

    Re: Run Time Error "1004": A table cannot overlap another table

    I am battling this exact same problem. There is no apparent reason for this error, the name I am giving the table does not exist prior. I finally just put in error handling, delete the table, then create it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run-time error "1004" Application defined or object-define-error
    By josros60 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-21-2013, 01:14 PM
  2. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  3. Run-time error 1004 Table Cannot Overlap A Range...
    By dearnemo385 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2012, 08:19 AM
  4. Run-time error 1004 Table Cannot Overlap A Range...
    By passmaster16 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2012, 10:21 AM
  5. Replies: 0
    Last Post: 05-09-2012, 03:59 PM

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