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