+ Reply to Thread
Results 1 to 2 of 2

My array name disappears - how can I find it??

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    My array name disappears - how can I find it??

    I have built several arrays (excel 2003). When creating the array I highlight the cells for the array and put a name in the name box to use for a vlookup function.

    It seems after I make the array I can click a different cell and then come back and hi-lite the array cells and the name re-appears in the name box, but after I make changes to other parts of the worksheet and go back to the array the name box no longer displays the array name.

    Is there a way to always display the name when hi-liting the array cells?

    I've attached a workbook with an array in worksheet CA_RR1 cells A28:B39 - WHEN i select those cells it just shows A28 in the name box.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: My array name disappears - how can I find it??

    Sorry, I've found the solution - the F5 function key shows a list of arrays and you press 'go' to highlight the array. I will mark this solved

+ 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] Array Find or Array Search
    By dluhut in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2014, 03:03 PM
  2. [SOLVED] Find Data in one array and match the position in another array
    By zeeman2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-27-2013, 07:55 PM
  3. [SOLVED] Find formula with multiple find (array)
    By dluhut in forum Excel General
    Replies: 3
    Last Post: 05-04-2012, 10:48 AM
  4. Find a value in an array and return multiple values in an adjacent array
    By tonbra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2012, 08:35 PM
  5. For Each Cell.Value within a 1D array, find each instance within a 2D array.
    By whilburn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2010, 04:51 PM
  6. Find if items in array A is in Array B
    By Klaatu in forum Excel General
    Replies: 2
    Last Post: 01-15-2009, 11:53 PM
  7. find each of the items in an array and save result in another array
    By lif in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2006, 08:54 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