| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting name of series - run-time error 1004
When I record macro in Excel 2003 and set name of series on a chart the
following code is saved: ActiveChart.SeriesCollection(1).Name = "=Workbook1!R1C1" When I do the same in Excel 2007, it generates: ActiveChart.SeriesCollection(1).Name = "=Workbook1!$A$1" Code from Excel 2003 does not work in Excel 2007 and vice versa - in both cases I get run-time error 1004. How can I create code compatibile with both versions of Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error 1004 when setting pivottable.pagefields | Excel Discussion (Misc queries) | |||
| Series Collection Results in Runtime Error 1004 | Excel Programming | |||
| Runtime Error 1004 Unable to set the XValues property of series cl | Excel Programming | |||
| Error 1004: Unable to set the XValues of the Series Class | Excel Programming | |||
| EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex | Excel Programming | |||
Linear Mode
