I have a number of named ranges in my workbook, so I typed all the names into cells to capture as a range unto itself. Now I want to use it do some function. Here is a quick example:
Dim X as string
A = Range("NamedRanges")
X = A(3,1)
Combobox1.RowSource = X
So I have the name of the range I want stored in X as a string, but I want to be able to use that to redefine a new range. I would settle for B = Range(X), but none of it works.
Any help would be great. Thanks in advance!
Dim X as string
A = Range("NamedRanges")
X = A(3,1)
Combobox1.RowSource = X
So I have the name of the range I want stored in X as a string, but I want to be able to use that to redefine a new range. I would settle for B = Range(X), but none of it works.
Any help would be great. Thanks in advance!