Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am unable to set the Location of a ChartObject using Excel 2003, VB 6.3.
The following code will return either Error 1004 or Run-time error '438': Object doesn't support this property or method. ActiveChart.Location Whe=xlLocationAsNewSheet, Name:="Test" However ActiveChart seems to be valid because immediately before (or after if the .Location line is commented out) other properties can be changed, e.g.: ActiveChart.Axes(xlValue, xlSecondary).MaximumScale = 0.6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
chart a location | Excel Discussion (Misc queries) | |||
workbook link failures | Links and Linking in Excel | |||
Excel 2002 : Need patching for formula failures | Excel Discussion (Misc queries) | |||
How to specify location for chart in VBA | Excel Discussion (Misc queries) | |||
Excel2000 VBA If-Then/Loop Failures | Excel Programming |