View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default .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