+ Reply to Thread
Results 1 to 3 of 3

Can arrays be identified by i = X TO Y statements? (Avoid select Case)

  1. #1
    Registered User
    Join Date
    01-25-2009
    Location
    hemsworth, england
    MS-Off Ver
    Excel 2003
    Posts
    25

    Can arrays be identified by i = X TO Y statements? (Avoid select Case)

    I would like to identify a number of arrays using a changing i. The idea is to avoid long lists of select case as shown in the code below. The ability to identify array names using this would be extremely helpful. Can it be done?

    eg point1A and point3B as pointiA and pointiB

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Can arrays be identified by i = X TO Y statements? (Avoid select Case)

    What goes on in the routine CombineTwoDArrays ?

    Maybe your post would make more sense if you posted full code and example dataset.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-25-2009
    Location
    hemsworth, england
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Can arrays be identified by i = X TO Y statements? (Avoid select Case)

    Sorry I will return to this and attempt to clarify my problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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