Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range
Hi
I would like to define a range like this: rnga = Range("D61:D96", "D101:D136", "D141:D176"). So I can use it in a spreadsheet formula such as this formula typed into cell D40: [D40] = STDEVP(rnga) I know I can use INSERT - NAME - DEFINE to define rnga but I would like to be able to do this through VBA. Is this possible ? Thanks in advance Andrew Bourke |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range
Sheets("whatever").Range("D61:D96, D101:D136, D141:D176").Name = "rnga"
Alan Beban Andrew B wrote: Hi I would like to define a range like this: rnga = Range("D61:D96", "D101:D136", "D141:D176"). So I can use it in a spreadsheet formula such as this formula typed into cell D40: [D40] = STDEVP(rnga) I know I can use INSERT - NAME - DEFINE to define rnga but I would like to be able to do this through VBA. Is this possible ? Thanks in advance Andrew Bourke |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a range
Andrew,.
the simplest way for you to figure this one out would be to use the macro recorder. Here's a long winded version. Sub NameRange() Dim rngA As Range Set rngA = Sheets(1).Range("D61:D96") Set rngA = Union(rngA, Sheets(1).Range("D101:D136")) Set rngA = Union(rngA, Sheets(1).Range("D141:D176")) Sheets(1).Names.Add Name:=Sheets(1).Name & "!" & "RangeA", _ RefersToR1C1:=rngA End Sub Robin Hammond www.enhanceddatasystems.com "Andrew B" wrote in message u... Hi I would like to define a range like this: rnga = Range("D61:D96", "D101:D136", "D141:D176"). So I can use it in a spreadsheet formula such as this formula typed into cell D40: [D40] = STDEVP(rnga) I know I can use INSERT - NAME - DEFINE to define rnga but I would like to be able to do this through VBA. Is this possible ? Thanks in advance Andrew Bourke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range naming | Excel Discussion (Misc queries) | |||
Naming a range | Excel Discussion (Misc queries) | |||
VB Code Naming a Range (range changes each time) | Excel Programming | |||
Naming a Range | Excel Programming | |||
Naming a Range with VB | Excel Programming |