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