Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nameing scattered data in chart (dot's) | Charts and Charting in Excel | |||
nameing a worksheet | Excel Discussion (Misc queries) | |||
Nameing cells in workbook | Excel Discussion (Misc queries) | |||
column nameing | Excel Discussion (Misc queries) | |||
In nameing a sheet in Excel it puts a .xls] in front why? | Excel Discussion (Misc queries) |