The only way I can replicate your problem is by spelling the name of the
chartobject wrong - i.e. if the ChartToCopy variable passes an incorrect
spelling you'll get this message. If the worksheet name is misspelled as
passed by the destinationSheet variable then I get the "subscript out of
range" message instead. Otherwise, your code works for me.

Regards,
Greg

"pwermuth" wrote:

>
> Can somebody help me fix the following:
>
> When I run the following line of code:
>
> Worksheets(destinationSheet).ChartObjects(chartToCopy).Activate
>
> where destinationSheet is a string with the name of the sheet "Output
> 2", and chartToCopy is also a string with the name of a chart "char 11"
>
> I get a "Run-time error '1004':
> Unable to get the ChartObjects property of the Worksheet class."
>
>
> I think it worked when I used
> Activesheet.ChartObjects(chartToCopy).Activate but I do not want to
> make it dependent on being on that sheet.
>
>
> --
> pwermuth
> ------------------------------------------------------------------------
> pwermuth's Profile: http://www.excelforum.com/member.php...o&userid=24997
> View this thread: http://www.excelforum.com/showthread...hreadid=386289
>
>