Range name as variable: possibe?

[KerryFSA]

Wrote a long explanation and it didn't post, so simply put: can a range be named using a variable?
e.g. Set Rng = "Range" & N
Then Rng becomes Range1, Range2, etc in a loop.

This works to name sheets as variables ( sh = "Sheet" & M).
Doesn't seem to work with a range name. Get "type mismatch" error.

Thanks.

 

[shg]

Assuming those are named ranges,

Set Rng = Range("Range" & N)

 

[KerryFSA]

Assuming those are named ranges,
Set Rng = Range("Range" & N)

yes Range1, Range2 etc are defined with values.
But the code still hangs up on the Set Rng statement. (1004 - Method 'Range' of object'_Global' failed.)

 

[shg]

yes Range1, Range2 etc are defined with values.

Defined how?

 

[KerryFSA]

Dim Range1 as Range, Range2 as range, Rng as Range
Set Range1 = .Range(.Cells(a,b), .Cells(c,d))
etc.
Is this what you mean?

 

[shg]

Ah, those are range variables, not range names.

No; VBA lacks reflection (I think that's the relevant attribute) that would enable you to access a variable by cobbling together its name.

There are surely other ways to do whatever it is you're trying to do, but I don't know what that is.

 

[KerryFSA]

I'm new enough that I don't understand the difference between a range variable and a range name.

There are other ways to deal with the issue; they're just a little less elegant. Thanks very much for your help.

 

[shg]

Holler if you need help.