Hello:
I have searched the archive, and the net, and can not find a solution to my problem. I know someone on this board knows a solution.
I have several different named ranges that are used for validating a column. I need to provide in a seperate column a validation that combines all of the seperate ranges into one.
NamedRange1 = a1:a3 {a1,a2,a3}
NamedRange2 = a4:A6 {a4,a5,a6}
where a1, a2, a3... are references to the cells that are the value.
What I need is the syntax to define a new range name such as:
CombinedRange = NamedRange1 + NamedRange2
which would not be a mathmatical addition, but a combined list such as:
CombinedRange = A1:A6 {a1, a2, a3, a4, a5, a6}
This message was edited by gvanbee on 2002-10-02 14:13
This message was edited by gvanbee on 2002-10-02 14:14
This message was edited by gvanbee on 2002-10-02 14:18
I have searched the archive, and the net, and can not find a solution to my problem. I know someone on this board knows a solution.
I have several different named ranges that are used for validating a column. I need to provide in a seperate column a validation that combines all of the seperate ranges into one.
NamedRange1 = a1:a3 {a1,a2,a3}
NamedRange2 = a4:A6 {a4,a5,a6}
where a1, a2, a3... are references to the cells that are the value.
What I need is the syntax to define a new range name such as:
CombinedRange = NamedRange1 + NamedRange2
which would not be a mathmatical addition, but a combined list such as:
CombinedRange = A1:A6 {a1, a2, a3, a4, a5, a6}
This message was edited by gvanbee on 2002-10-02 14:13
This message was edited by gvanbee on 2002-10-02 14:14
This message was edited by gvanbee on 2002-10-02 14:18