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