| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to define a Named Range in VBA?
I'm trying to define a named range in VBA using the following syntax.
However, it gives me an error regarding the equal sign and if I remove the equal sign, then the named range is defined but it treats the formula as a text value so it doesn't evaluate it. I'm sure there's something easy that I'm overlooking but what is it? Any help is appreciated. ActiveWorkbook.Names.Add Name:="PivotRange", RefersToR1C1:= _ "=OFFSET(Sheet1!$A$1,0,0,COUNTA(Shee1!A:A),10) '" -- Richard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a cell value define a dynamic named range? | Excel Worksheet Functions | |||
| How to Define a named Formula at the Worksheet level? | Excel Worksheet Functions | |||
| Define a range based on another named range | Excel Worksheet Functions | |||
| Automatically define series of named ranges | Excel Programming | |||
| Help with named constants in Define Name dialog box!!!! | Excel Programming | |||
Threaded Mode
