View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wayne Wayne is offline
external usenet poster
 
Posts: 133
Default 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