I have workbook with circle to which excel2007 has assigned the range name "Oval 1". It is in the Sheet1 tab in the work book. code copies and pastes it to Sheet2 tab. When this is done, excel2007 assigns the range name "Oval 1" to it. It is then pasted to another cell in Sheet2 and it becomes "Oval 2". THAT'S ONE BEHAVIOR.

In another workbook, the exact same thing is being done with the same kind of code and BOTH objects in the Sheet2 are called "Oval 1".

WHY IS THAT? WHAT CONTROLS THIS BEHAVIOR?

Here's the code:
Sheets("Sheet1").Select
ActiveSheet.DrawingObjects("Oval 1").Select
Selection.Copy
Sheets("Sheet2").Select
Range("CellforOval1").Select
ActiveSheet.Paste

Range("CellforOval1").Offset(5, 0).Select
ActiveSheet.Paste

Thanks