Programatically nameing ranges

[Adam Ward]

I have a list in Cells A1:A(x)and C1:C(x)where (x) can
change, I know (x).

How do I programatically Name the Range

Thanks

Adam

 

[Bob Phillips]

Range("A1:A" & x).Name = "range1"

Range("C1:C" & x).Name = "range2"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks

But I also want the final named range to refer ,by one
name to all the cells in A1:A(x) and C1:C(x) but when I
do that

Range("A1:A" & (x), "C1:C" & (x)).Name = "range3"

I get returned A1:C(x)

I'm probably being very stupid here!

Adam

 

[Bob Phillips]

Adam,

Give this a try then

Union(Range("A1:A" & x), Range("C1:C" & x)).Name = "Bob1"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dana DeLouis]

One of a few ways:

x = 10
Union([A1].Resize(x), [C1].Resize(x)).Name = "MyName"