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


.