Drange w/ refers to is =OFFSET(Hrs!$A$2,0,0,End-1,4)
End w/ refers to is =MATCH(9.9999999E+307,Hrs!$D:$D)
In the Drange I see the sheet/row/col but loose it with End-1,4). What does End-1,4 refer to? Ibelieve the 'D' in Drange refers to col D on sheet hrs?????
In the =MATCH the sheet/range is understood, but what does the 9.9999999+307 refer to?
The point is I would like to name some more ranges using the OFFSET/MATCH routine. I can imagine for the Drange using perhaps another col heading on the other sheet like 'Erange refers to =OFFSET(SHEET!$A$2,0,0,End-1,4). Then it's a matter of the End part - how End was choosen for the =MATCH and what another good =MATCH name would be.
You see, it would help if I understood how things inter-relate.
Looks like a strange question to me - but hey - I gotta ask.
tfyh
End w/ refers to is =MATCH(9.9999999E+307,Hrs!$D:$D)
In the Drange I see the sheet/row/col but loose it with End-1,4). What does End-1,4 refer to? Ibelieve the 'D' in Drange refers to col D on sheet hrs?????
In the =MATCH the sheet/range is understood, but what does the 9.9999999+307 refer to?
The point is I would like to name some more ranges using the OFFSET/MATCH routine. I can imagine for the Drange using perhaps another col heading on the other sheet like 'Erange refers to =OFFSET(SHEET!$A$2,0,0,End-1,4). Then it's a matter of the End part - how End was choosen for the =MATCH and what another good =MATCH name would be.
You see, it would help if I understood how things inter-relate.
Looks like a strange question to me - but hey - I gotta ask.
tfyh