Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a name with VBA
I have an obscure problem. I have simplified it down to the code below. I
am trying to create a named range with VBA but the range name has inverted commas around it so it will not work. For example, the code below creates a named range for ResourceList of: ="Sheet2!$A$1:$A$3" rather than =Sheet2!$A$1:$A$3 (with no inverted commas) "Sub test() Dim strStart As String Dim strEnd As String Dim strAddress As String strStart = "$A$1" strEnd = "$A$3" strAddress = ActiveWorkbook.Name & "!" & strStart & ":" & strEnd ActiveWorkbook.Names.Add Name:="ResourceList", RefersToR1C1:=strAddress End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a new key | Excel Discussion (Misc queries) | |||
creating Yes,No | Excel Discussion (Misc queries) | |||
Creating Id | Excel Worksheet Functions | |||
Really need help creating pop ups | Excel Discussion (Misc queries) | |||
Creating a Log | Excel Programming |