| 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 |
| 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 | |||
Threaded Mode
