Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hi Monsoor,
Change Cells(6, i) to Cells(49,i) I omitted to amend my test! --- Regards, Norman "Norman Jones" wrote in message news:... 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hi Monsoor:
Please totally disregard my last message. My first message is correct!! --- Regards, Norman "Norman Jones" wrote in message ... Hi Monsoor, Change Cells(6, i) to Cells(49,i) I omitted to amend my test! --- Regards, Norman "Norman Jones" wrote in message news:... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hi Norman,
This works fine. Thanks for your help. Saved me from lot of typings and a very long macro. Thanks. Regards Monsoor -----Original Message----- Hi Monsoor: Please totally disregard my last message. My first message is correct!! --- Regards, Norman "Norman Jones" wrote in message ... Hi Monsoor, Change Cells(6, i) to Cells(49,i) I omitted to amend my test! --- Regards, Norman "Norman Jones" wrote in message news:... 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 | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Range Selection | Excel Programming | |||
Creating range name for a range selection | Excel Programming | |||
range selection | Excel Programming |