View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Booker Dave Booker is offline
external usenet poster
 
Posts: 8
Default Chart .Location failures

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