+ Reply to Thread
Results 1 to 4 of 4

Macro bug keeps saying Table already exists when I have not created any tables

  1. #1
    Registered User
    Join Date
    06-16-2023
    Location
    Pennsylvania, PA
    MS-Off Ver
    2016
    Posts
    2

    Macro bug keeps saying Table already exists when I have not created any tables

    I will post the code below but I keep getting errors such as "Table 2 already exists" when I try and run the macro I just created to format data. When creating the macro I just pressed record and then went into power query to delete some columns and move some stuff around so not sure what is going on. Any help is very appreciated thanks!

    Cross-posted here: https://www.mrexcel.com/board/thread...un-it.1239443/


    Please Login or Register  to view this content.
    Last edited by Glenn Kennedy; 06-16-2023 at 10:26 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Macro bug keeps saying Table already exists when I have not created any tables

    Welcome (back) to the forum.


    Please take a moment and READ the forum rules. You managed to break Rules 2 and 3 with this one!!


    https://www.excelforum.com/forum-rul...rum-rules.html


    Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

    But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

    Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

    1) if you have cross-posted, and

    2) the URL of the cross posts.

    That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.


    However, since you are either a new member or a very infrequent user, on this occasion, I have done it for you. Is it cross-posted anywhere else?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    293

    Re: Macro bug keeps saying Table already exists when I have not created any tables

    I've not had a chance to dive deep, but first thing I spot is;

    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    Two items with the same name.

  4. #4
    Registered User
    Join Date
    06-16-2023
    Location
    Pennsylvania, PA
    MS-Off Ver
    2016
    Posts
    2

    Re: Macro bug keeps saying Table already exists when I have not created any tables

    Thank you for the reply, I am new to VBA so should I change the second table name to Table3?

+ 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. [SOLVED] Dynamic tables, search if table header exists and if not, give message
    By mstgier in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2023, 05:27 AM
  2. [SOLVED] Macro to created Database from a Table Matrix on All Sheets in a Workbook
    By rehana402003 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-13-2022, 02:52 PM
  3. [SOLVED] Link two different tables together over 1 code that exists in both tables.
    By luca.pe in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2022, 04:03 AM
  4. Introducing a dynamic heading to created PDF Files created by macro
    By Romoluzzi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2020, 05:42 AM
  5. Macro to display a message box if specific text exists in a table
    By estewart423 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2017, 05:39 PM
  6. Can't do Calculated Field in a pivot table created from multiple tables?
    By jcurtin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-26-2014, 09:59 AM
  7. Add vba to current macro to copy table into newly created sheet
    By Morgraal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2013, 07:10 AM

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