VBA conditional selection of rows in table with multiple ranges/arrays

[zeno]

Hi,

I have an Excel table with different dates, times, etc. This table can be divided into 3 ranges or arrays, where I compare between the 3 on a time dimension.

'A' --- 'B' --- 'C'
date - time - range 1
date - time - range 1
date - time - range 2
date - time - range 3
date - time - range 3
date - time - range 3
etc.

I'd like to know how in VBA I can define the 3 different ranges for variable number of rows. If I can do so, how can I then compare between the ranges for time?

Thank you for your help.