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.
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.