+ Reply to Thread
Results 1 to 3 of 3

Global array (that name manager thing) question

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    Bulgaria
    MS-Off Ver
    2016
    Posts
    11

    Global array (that name manager thing) question

    I am reworking one of my tables, clearing it up, making it more readable, and other stuff like that.
    I have one array of 500 rows, which I want to transfer to the name manager, and then delete its source, without that affecting the values in the name manager.
    Any suggestions how can I do that without manually writing all the values in the manager?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Global array (that name manager thing) question

    Names are used to name MS Excel objects like cells, cell ranges, tables, formulas, constants, etc.
    Names do not hold data, they are "pointers" to the data:
    ...how can I do that without manually writing all the values in the manager...: You can't do that.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    04-25-2017
    Location
    Bulgaria
    MS-Off Ver
    2016
    Posts
    11

    Re: Global array (that name manager thing) question

    Can't I make a macro to do it for me?
    One that creates a name, and loops trough my array, filling in the elements?

    Edit: I'm trying out to do this:

    Please Login or Register  to view this content.
    But I'm getting application-defined or object-defined error.

    Edit 2:
    I tried this code for a range of numbers (instead of range of strings (I removed the quotation marks (Chr(34)))), and it works.
    So I just need to figure out how to make it work for an array of strings.

    EDIT 3: The code actually works. Problem was that my array was too long for the name manager. Fixed that by splitting my array in 2.
    Last edited by WereElf; 05-02-2017 at 10:24 AM.

+ 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] Analysis - Scenario Manager question
    By Exequiel3k in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-10-2016, 03:03 PM
  2. Analysis - Scenario Manager question
    By Exequiel3k in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2016, 07:33 AM
  3. Enter Array Formula in Name Manager and have it work
    By Jessop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2015, 02:05 PM
  4. Global Array
    By peternorth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2013, 10:12 AM
  5. Is there such thing as conditional array?
    By pauliano in forum Excel General
    Replies: 4
    Last Post: 11-26-2006, 12:06 PM
  6. [SOLVED] Simple Question..if there is such a thing in Excel
    By Don in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2006, 01:10 PM
  7. scenario manager programming question
    By daizy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2005, 12:05 AM

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