.addline error duplicate name
Are you sure the name is in the same sheet? It will assign the same name
to a line on sheet 2 as on sheet 1 and other sheets. But I have never seen
it assign the same name to a shape on the same sheet. Look for Sheet1!Line1
and Sheet2!Line1 for names. The sheet name should differentiate between the
line names.
"perf" wrote in message
...
Hi,
I having a problem using .addline method in VBA code. I am using office
2007
and .xls format (for compatibility with office 2003 reasons) files:
when I draw a new line with this .addline method, I see that the sometimes
(not always, quite randomly) the name given to the new line is already
existing in the sheet. so later in the program, I have a lot of problem
grouping the blocks (excel cannot choose the right shape by name)
how is it possible that addline method does this duplication?
many thanks in advance
Mark
|