| 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 |
| 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 | |||
Threaded Mode
