Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named ranges and variables
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Variables and Ranges | Excel Discussion (Misc queries) | |||
Using named variables | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
using variables to set ranges | Excel Programming |