Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating NamedRanges with VBA
Im having difficulty in creating a named range programmatically and getting
it to appear in the goto box. The following code DOES create a named range, but the refference has quotes around it and therefore does not appear in the goto box. Does anyone know what I am doing wrong ? Dim mr As String mr = "Sheet1!myRange3" 'Create Range Call ThisWorkbook.Names.Add(Name:=mr, RefersTo:="Sheet1!$A$1:$C$3", Visible:=True) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating NamedRanges with VBA
Sorry should have read
Dim mr As String mr = "Sheet1!$A$1:$C$3", 'Create Range Call ThisWorkbook.Names.Add(Name:="myRange", RefersTo:=mr, Visible:=True) "Goofy" wrote in message ... Im having difficulty in creating a named range programmatically and getting it to appear in the goto box. The following code DOES create a named range, but the refference has quotes around it and therefore does not appear in the goto box. Does anyone know what I am doing wrong ? Dim mr As String mr = "Sheet1!myRange3" 'Create Range Call ThisWorkbook.Names.Add(Name:=mr, RefersTo:="Sheet1!$A$1:$C$3", Visible:=True) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating NamedRanges with VBA
ItsOK, I worked it out, there should have been an equal sign before the
reference "Goofy" wrote in message ... Sorry should have read Dim mr As String mr = "Sheet1!$A$1:$C$3", 'Create Range Call ThisWorkbook.Names.Add(Name:="myRange", RefersTo:=mr, Visible:=True) "Goofy" wrote in message ... Im having difficulty in creating a named range programmatically and getting it to appear in the goto box. The following code DOES create a named range, but the refference has quotes around it and therefore does not appear in the goto box. Does anyone know what I am doing wrong ? Dim mr As String mr = "Sheet1!myRange3" 'Create Range Call ThisWorkbook.Names.Add(Name:=mr, RefersTo:="Sheet1!$A$1:$C$3", Visible:=True) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating NamedRanges with VBA
Simpler
worksheets("Sheet1").Range("$A$1:$C$3").Name = "myRange" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Goofy" wrote in message ... ItsOK, I worked it out, there should have been an equal sign before the reference "Goofy" wrote in message ... Sorry should have read Dim mr As String mr = "Sheet1!$A$1:$C$3", 'Create Range Call ThisWorkbook.Names.Add(Name:="myRange", RefersTo:=mr, Visible:=True) "Goofy" wrote in message ... Im having difficulty in creating a named range programmatically and getting it to appear in the goto box. The following code DOES create a named range, but the refference has quotes around it and therefore does not appear in the goto box. Does anyone know what I am doing wrong ? Dim mr As String mr = "Sheet1!myRange3" 'Create Range Call ThisWorkbook.Names.Add(Name:=mr, RefersTo:="Sheet1!$A$1:$C$3", Visible:=True) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating NamedRanges with VBA
Thanks bob
"Bob Phillips" wrote in message ... Simpler worksheets("Sheet1").Range("$A$1:$C$3").Name = "myRange" -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Goofy" wrote in message ... ItsOK, I worked it out, there should have been an equal sign before the reference "Goofy" wrote in message ... Sorry should have read Dim mr As String mr = "Sheet1!$A$1:$C$3", 'Create Range Call ThisWorkbook.Names.Add(Name:="myRange", RefersTo:=mr, Visible:=True) "Goofy" wrote in message ... Im having difficulty in creating a named range programmatically and getting it to appear in the goto box. The following code DOES create a named range, but the refference has quotes around it and therefore does not appear in the goto box. Does anyone know what I am doing wrong ? Dim mr As String mr = "Sheet1!myRange3" 'Create Range Call ThisWorkbook.Names.Add(Name:=mr, RefersTo:="Sheet1!$A$1:$C$3", Visible:=True) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating Yes,No | Excel Discussion (Misc queries) | |||
Creating Id | Excel Worksheet Functions | |||
Really need help creating pop ups | Excel Discussion (Misc queries) | |||
ClearContents - Except NamedRanges | Excel Programming | |||
Creating an XLL with C# | Excel Programming |