Adamski
12-15-2009, 08:50 AM
Hello,
I have a named range refering ("Head") to a number of contigious cells on one row ("D4:H4".
How do I get an equivalent range of the same columns but on a specific row?
eg. "D6:H6", or "D13:H13"
I can use Offset and subtract the "Head" row number, but is there a better way.
Thanks
I have a named range refering ("Head") to a number of contigious cells on one row ("D4:H4".
How do I get an equivalent range of the same columns but on a specific row?
eg. "D6:H6", or "D13:H13"
I can use Offset and subtract the "Head" row number, but is there a better way.
Thanks