Use of macros on spreadhseet copies
 

I have a spreadsheet with quite a few macros defined. All the macros work
with the original sheet. However, when I create a copy of the sheet in the
same workbook, this macro statement crashes:


"ActiveSheet.Shapes(Cell(i,32).Value).IncrementLef t 660"

The value of the index (Cell(i,32).Value) is a string and is defined;
ActiveSheet.Shapes with that index cannot be found in the copied sheet.

Help!

--
VB Amateur

Use of macros on spreadhseet copies
 

hape names will change when you copy a sheet if you use the default shapes name

I put 3 rectangles on a sheet and the default names were
Rectangle 1
Rectangle 2
Rectangle 3

I then deleted rectangle 2. Next I copied the sheet to a new sheet. The
new sheet had

Rectangle 1
Rectangle 2

Excel rename Rectangle 3 to rectangle to on the new sheet.

I then repeated the experiment by rename the rectangles MyRect1 and MyRect3.
when the sheet was copied the names of the rectangles again were changed

MyRect1
MyRect2

Finally I put a number at the middle instead of the end and the names didn't
change.

My1Rect
My3Rect



"Wayne" wrote:

I have a spreadsheet with quite a few macros defined. All the macros work
with the original sheet. However, when I create a copy of the sheet in the
same workbook, this macro statement crashes:


"ActiveSheet.Shapes(Cell(i,32).Value).IncrementLef t 660"

The value of the index (Cell(i,32).Value) is a string and is defined;
ActiveSheet.Shapes with that index cannot be found in the copied sheet.

Help!

--
VB Amateur