W
Wayne
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).IncrementLeft 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!
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).IncrementLeft 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!