+ Reply to Thread
Results 1 to 5 of 5

Store Values in array

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Store Values in array

    Hello
    I have numbers in column A (A1:A9)
    The following code extract the missing numbers and put the values in Column D

    I want to change the code so as to store the values (missing numbers) in array and finally use Msgbox to list all the values once in a message
    Please Login or Register  to view this content.
    Here's an attachment
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Store Values in array

    Hi Yasser,

    Try this:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Store Values in array

    Hi,

    this is your code with the changes made to suit your needs, hope this helps.

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  4. #4
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Store Values in array

    Mr. xladept
    Mr. xlbiznes

    Thank you very much for your great help

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Store Values in array

    You're welcome!

+ 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. Store array formula content in a VBA array
    By cgkmal in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-19-2013, 02:24 PM
  2. [SOLVED] Store value from an array in new variable
    By vizzkid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 05:03 AM
  3. Store cell values in an array and return values on specific condition
    By gmalpani in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 11-27-2011, 06:43 AM
  4. Store Found values directly in array
    By cgkmal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-15-2011, 04:41 PM
  5. Array does not store value
    By yeaster in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-02-2008, 11:36 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