Hello 
Here's my problem: I have a table with Date, Time and Value.
The Value is dependent on both the Time in its Row and the Min Time of the Date.
What I want to do is get the Min Time of the Date and use it as a reference in VB, because at the moment I'm simply using the manually input value (Range("B2")).
So if I have values like
Date Time
2012.01.01 7:30
2012.01.01 8:30
2012.01.01 9:30
2012.01.02 8:00
2012.01.02 9:20
2012.01.02 9:50
the absolute references to the Min Time would be B2 and B5, accordingly.
Here's my problem: I have a table with Date, Time and Value.
The Value is dependent on both the Time in its Row and the Min Time of the Date.
What I want to do is get the Min Time of the Date and use it as a reference in VB, because at the moment I'm simply using the manually input value (Range("B2")).
So if I have values like
Date Time
2012.01.01 7:30
2012.01.01 8:30
2012.01.01 9:30
2012.01.02 8:00
2012.01.02 9:20
2012.01.02 9:50
the absolute references to the Min Time would be B2 and B5, accordingly.
