+ Reply to Thread
Results 1 to 1 of 1

VBA arrays in a range: sorting

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    39

    VBA arrays in a range: sorting

    Hello,

    I have 1 table/range in Excel, that I need to subdivide into 3 parts (arrays?). The division into 3 parts is made by 3 values (1,2,3) from a column 'D'.
    I have to find out if cell 'data' from 1 array also appears in the other 2 arrays.

    Table/range example:
    'A' --- 'B' --- 'C' --- 'D' (columns)
    day 1 - time 1 - data 1 - value 1
    day 1 - time 2 - data 2 - value 1
    day 1 - time 3 - data 1 - value 1
    day 1 - time 1 - data 2 - value 2
    day 1 - time 1 - data 1 - value 3
    ...

    I wrote code that I hoped would select an array for 'value 1'. However, instead it select the whole table (range).
    How can I select only the rows with either 'value 1' or 'value 2' or 'value 3'? With those selection, I then want to make comparisons.

    Please Login or Register  to view this content.
    I'm looking into a 'Range.Group' method, but this seems to be only possible if the object is a single cell?
    Possibly multiple-area ranges could work.
    Thank you for any suggestions.
    Last edited by zeno1; 09-27-2012 at 06:28 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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