Single quotes in named range

V

Vik Mehta

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
 
H

Harlan Grove

Vik Mehta said:
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?
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox to name a range 2
No response to change_event 4
VBA - exporting serial letters to single documents 0
Creating a defined name's Refersto range 2
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Name the range AFTER copied to new sheet 6
What am I doing wrong with Ranges named within Macro... 7
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6

Top