Thanks to everyone for your suggestions and comments :-)

It actually makes sense that names looking like cell references cannot
be used - so, I've chanced the names to a more 'error free' system .-)

Thanks...

CE



Den 19.04.2012 19:29, Charlotte E. skrev:
I'm trying to add the following names to a workbook:

ActiveWorkbook.Names.Add Name:="A03_01", RefersToR1C1:=...
ActiveWorkbook.Names.Add Name:="B03_01", RefersToR1C1:=...
ActiveWorkbook.Names.Add Name:="C03_01", RefersToR1C1:=...
ActiveWorkbook.Names.Add Name:="D03_01", RefersToR1C1:=...
ActiveWorkbook.Names.Add Name:="E03_01", RefersToR1C1:=...

BUT!

Number 3:

ActiveWorkbook.Names.Add Name:="C03_01", RefersToR1C1:=...

Fails, with a message, saying that the name is invalid?!?

Why is "C03_01" invalid, and the rest are OK?!?


Thanks in advance...


CE