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