If U = "MyCell1,MyCell2", where "MyCell1" and "MyCell2"
are legit range names, then the expression Range(U)
returns a real range (which I just tested & it works).

First off, note that I changed your S variable back to the U variable so as
to match your initial setup. I did this because I wanted to draw your
attention to the fact that with this...

S = "MyCell1"
T = "MyCell2"

when I asked you if you had meant to write this...

U = S & "," & T

I did that because that would make...

U = "MyCell1,MyCell2"

which is what you referred to in your quoted text at the top of this reply.

--
Rick (MVP - Excel)


"Jim Luedke" wrote in message
...
Rick:

Thanks very much for reply.

You are clearly right, and I am clearly wrong, on both counts.

On the first, I did not in fact check to see exactly what the extent
of the range returned by the expression was.

On the second, I took my zeal over indirectness one level too far. I
should have said:

If S = "MyCell1,MyCell2", where "MyCell1" and "MyCell2" are legit
range names, then the expression Range(S) returns a real range (which
I just tested & it works).

Which, as I said, to a quasi-newbie like myself, seems kinda amazing.

Thanks much again.

***