| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chart select causes error 1004
The code at the bottom use to work in Excel 2003 but now in Excel 2007 I get
the error message when it executes the ActiveSheet line: Run-time error '1004': Application-defined or object-defined error --------------------------------------------------------------------------------------------- dim shtcnt as integer For shtcnt = 2 To (ActiveWorkbook.Sheets.Count - 1) ActiveWorkbook.Sheets(shtcnt).Select ActiveSheet.ChartObjects("xyz chart").Select --------------------------------------------------------------------------------------------- I have verified that "xyz chart" exists by selecting the chart with Alt + mouse click and seeing the name in the Name Box left of the Formula Bar. Any ideas whats wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 1004 using array in Sheet select. | Excel Discussion (Misc queries) | |||
| Select method of range class failed, Run time error 1004 | Excel Programming | |||
| RT Error 1004, Select method of worksheet class failed | Excel Programming | |||
| Run-time 1004 error on range select | Excel Programming | |||
| error 1004 Select method of Range class failed | Excel Programming | |||
Threaded Mode
