updating a value in a named range

[dchillman]

I have a template to create new excel worksheets. It has several cells defined with a named range. I thought I would be able to use something like to put a value in the named cell, but I get an error "StartIndex cannot be less than zero"

worksheet.range["rangename"].Value = "abcd";

can someone point me in the right direction?

thanks

[Betsy.jiang]

Dear dchillman,

Sorry for late reply as weekend.
Please make sure the rangename is same as the name defined in the template file. If there still is issue, please provide us the template file for investigation.

Thanks,
Betsy
E-iceblue support team

[Betsy.jiang]

Dear dchillman,

Has the issue been resolved ? If not, please provide us the template file and code your were using for investigation.

Sincerely,
Betsy
E-iceblue support team