B
boris
definitely works. You got it. Thanks. One more
problem, which I'll post separately...If I use the
Indirect method, I can only be on step removed from the
value. In other words, it seems I can't use in the
Indirect argument a cell (or combination of cells) that
spell the name of the range I want. Example:
A1 = b2 b2 = 2 C2= A C3 = 1
A2 is named test
Indirect (A2) gives me 2...great
Indirect (text(c2,"#")&text(c3,"#")) gives b2, as opposed
to 2, which is what I want.
Boris
problem, which I'll post separately...If I use the
Indirect method, I can only be on step removed from the
value. In other words, it seems I can't use in the
Indirect argument a cell (or combination of cells) that
spell the name of the range I want. Example:
A1 = b2 b2 = 2 C2= A C3 = 1
A2 is named test
Indirect (A2) gives me 2...great
Indirect (text(c2,"#")&text(c3,"#")) gives b2, as opposed
to 2, which is what I want.
Boris