Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hi All,
What I want to do is simple but can't figure it out. I have a range as follow: Dim Rng as Range Set Rng = Range ("A2:A6") I want to name this range Rng.name = "Chart1" What I want to do is to name the same number of cells in columns B to AW in the same rows by adding the column number to the name like above. So range("B2:B6")would be named as "Chart2". I can do this by: rng.offset(0,1).name = "Chart2" This means I will have to do it 49 times! There must be an easier way of getting the same result. Help is appreciated. Thanks in advance. Regards Monsoor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hi Monsoor,
Try: Sub Test() Dim i As Long For i = 1 To 49 Range(Cells(1, i), Cells(6, i)).Name = "Charts" & i Next i End Sub --- Regards, Norman "Monsoor" wrote in message ... Hi All, What I want to do is simple but can't figure it out. I have a range as follow: Dim Rng as Range Set Rng = Range ("A2:A6") I want to name this range Rng.name = "Chart1" What I want to do is to name the same number of cells in columns B to AW in the same rows by adding the column number to the name like above. So range("B2:B6")would be named as "Chart2". I can do this by: rng.offset(0,1).name = "Chart2" This means I will have to do it 49 times! There must be an easier way of getting the same result. Help is appreciated. Thanks in advance. Regards Monsoor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range selection | Excel Discussion (Misc queries) | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Selection Range | Excel Discussion (Misc queries) | |||
Creating range name for a range selection | Excel Programming |