Programatically nameing ranges
 

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

Programatically nameing ranges
 

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)

"Adam Ward" wrote in message
...
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

Programatically nameing ranges
 

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
-----Original Message-----

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)

"Adam Ward" wrote in message
...
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


.

Programatically nameing ranges
 

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)

wrote in message
...
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
-----Original Message-----

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)

"Adam Ward" wrote in message
...
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


.

Programatically nameing ranges
 

One of a few ways:

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

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Adam Ward" wrote in message
...
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