automation prevent double quotes in RefersTo workbook name definition

[bart tuytten]

Hello,

i intend to create some named constant in a workbook.
I generated some code where a string called Str contains the following by e.g. text {3,4;5,6}.
I.e. an array that can be of any shape when automated.

As soon as i define a new workbook name by entering the Str in the RefersTo parameter by the following:

ActiveWorkbook.Names.Add Name:=Name, RefersTo:=Str

It results in the name manager's formula as ="{3,4;5,6}", instead of ={3,4;5,6}
So I'd rather not have these double quotes appear.

Any suggestion how to cope this issue is very welcome.

Regards,
Bart Tuytten

 

[Tetra201]

Try

ActiveWorkbook.Names.Add Name:=Name, RefersTo:=Evaluate(Str)

 

[bart tuytten]

Try

ActiveWorkbook.Names.Add Name:=Name, RefersTo:=Evaluate(Str)

Works really fantastic now. Thx for the input

 

[Tetra201]

Glad to have helped.