Hi,

Dim CurRange as Range
Dim i as integer

i = 1 ' or i=2 ... set your condition

Set CurRange = Worksheets("Docs").Range("MyRange" & i)
CurRange.Select


HTH

"Mats Samson" wrote:

Hello,
I'd like to select a named range that can be different depending the
conditions, and
I'd like to use a variable to contain the named range but the statement
Worksheets("Docs").Range(CurRange).Select
won't accept the CurRange variable.
Let's say I have two named ranges: myRange1 ( for the range a1:b1) and
myRange2 (for the named (range) single cell a7). Depending of the conditions
I wan't to set CurRange to contain either myRange1 or myRange 2 and the
program to select the right range. (I need to use named ranges as the
position of the named ranges will change during time.)
Is there any good solution?

Best regards
Mats Samson