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.