Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greyed out area on the spreadhseet | Excel Discussion (Misc queries) | |||
Reset Bottom of an Excel spreadhseet | New Users to Excel | |||
2 copies of my spreadhseet open! | Excel Worksheet Functions | |||
how to put the subtotal of the sum and count in one spreadhseet? | Excel Worksheet Functions | |||
subtotal of sum and count in one spreadhseet? | Excel Worksheet Functions |