| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Single quotes in named range
I am defining a name for a range using
ActiveWorkbook.Names.Add Name:=strDefName, RefersTo:=strRange. strDefName has a single quote in it and it's causing an error. Can anyone help me with this? Thanks. Vik |
|
#2
|
|||
|
|||
|
Hi
could you post your exact strDefName assignment -- Regards Frank Kabel Frankfurt, Germany "Vik Mehta" schrieb im Newsbeitrag om... I am defining a name for a range using ActiveWorkbook.Names.Add Name:=strDefName, RefersTo:=strRange. strDefName has a single quote in it and it's causing an error. Can anyone help me with this? Thanks. Vik |
|
#3
|
|||
|
|||
|
"Vik Mehta" wrote...
I am defining a name for a range using ActiveWorkbook.Names.Add Name:=strDefName, RefersTo:=strRange. strDefName has a single quote in it and it's causing an error. Can anyone help me with this? No way to help. Defined names may contain letter, decimal digits and underscores. Nothing else. You can't put a single quote into a name. |
|
#4
|
|||
|
|||
|
Here is the strDefName assignment:
"A_Carol_O'Henry_UT" Thanks, Vik "Frank Kabel" wrote in message ... Hi could you post your exact strDefName assignment -- Regards Frank Kabel Frankfurt, Germany "Vik Mehta" schrieb im Newsbeitrag om... I am defining a name for a range using ActiveWorkbook.Names.Add Name:=strDefName, RefersTo:=strRange. strDefName has a single quote in it and it's causing an error. Can anyone help me with this? Thanks. Vik |
|
#5
|
|||
|
|||
|
Hi
see Harlan's response -- Regards Frank Kabel Frankfurt, Germany "Vik Mehta" schrieb im Newsbeitrag om... Here is the strDefName assignment: "A_Carol_O'Henry_UT" Thanks, Vik "Frank Kabel" wrote in message ... Hi could you post your exact strDefName assignment -- Regards Frank Kabel Frankfurt, Germany "Vik Mehta" schrieb im Newsbeitrag om... I am defining a name for a range using ActiveWorkbook.Names.Add Name:=strDefName, RefersTo:=strRange. strDefName has a single quote in it and it's causing an error. Can anyone help me with this? Thanks. Vik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| ClearContents method on a passed range | New Users to Excel | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Linear Mode
