Hi
I have a Named Range, being:
Although I can treat this as a contiguous range within VBA, I am yet to find a worksheet way to do the same. For example:
returns a '#REF!' error.
Sure, I can split up the range into a series of contiguous ranges and then aggregate them, but this would then defeat the purpose of having a single, non-contiguous, range.
Any help greatly appreciated.
Cheers
pvr928
I have a Named Range, being:
Code:
TEST_Range =TEST!$D$3:$D$9,TEST!$D$14:$D$22
Although I can treat this as a contiguous range within VBA, I am yet to find a worksheet way to do the same. For example:
Code:
=ROWS(Test_Range)
returns a '#REF!' error.
Sure, I can split up the range into a series of contiguous ranges and then aggregate them, but this would then defeat the purpose of having a single, non-contiguous, range.
Any help greatly appreciated.
Cheers
pvr928