+ Reply to Thread
Results 1 to 1 of 1

Can't name a table as the name exists, but it does not!?

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    583

    Can't name a table as the name exists, but it does not!?

    Getting real frustrated here.

    In a couple instances I created tables and assigned them names through the Name Manager. Later I chose to change the organization of the tables so I deleted them and their names through the Name Manager, then created the new tables. The names I previously used do not show up in the Name Manager. Now when I try to assign either name to a newly created table I get told that the name exists and get kicked back to try another.

    Any ideas as to what is going on? One instance involves a table that already has a multitude of references to it in my code and if I can't use the name it is going to be a MAJOR PITA to go through and modify the code, find & replace or not!!!

    Thank-you!


    Edit: Just ran Code Cleaner and it fixed the problem. Leaving this up in case anyone else has this nightmare...
    Last edited by brucemc777; 11-04-2015 at 08:11 PM. Reason: Solution

+ 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] Check if a value exists in a table
    By Kappany in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2015, 02:42 AM
  2. Wanted to know if data already exists in Table
    By SriramDorai in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2014, 01:48 PM
  3. Checking if a table already exists
    By JoeSkittles in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-16-2013, 09:11 AM
  4. VBA Code to check If value exists in a table
    By ysrikhanta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2012, 05:09 AM
  5. Replies: 6
    Last Post: 08-04-2011, 12:18 PM
  6. IF assistance to check if value exists in a table first
    By penfold in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-14-2010, 11:46 AM
  7. If Pivot Table Exists
    By hoppermr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2006, 12:50 PM

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