Select a chart from a chartsheet in VBA

**BillDoor** · 12-09-2015, 05:13 AM

I'm trying to write some code that will select a chart froim a chartsheet to copy it, but I can't seem to get it work.
I had a similar code to select a chart that was part of a worksheet that worked fine.

the line I'm using is

Please Login or Register  to view this content.

But I get the error - The item with the specified name wasn't found
the name of the tab and the charts are both STP% Chart
Any ideas please?

**Kaper** · 12-09-2015, 08:33 AM

first: if tou try to assign chartobject, it shall be done with Set instruction
second: shouldnt it refer to named chcart in current sheet, like

Please Login or Register  to view this content.

?

**BillDoor** · 12-09-2015, 09:16 AM

hi

that still doesn't work, same error

**Kaper** · 12-09-2015, 11:12 AM

Some errors are obvious, some less. While in case of obvious one, sample file is useless, for "not so obvious" case attachment could clarify a lot :-)

**Norie** · 12-09-2015, 11:18 AM

Isn't the chart sheet itself the chart?

**BillDoor** · 12-10-2015, 07:02 AM

Hi all

seem to have stumbled on the answer - this does the trick

Please Login or Register  to view this content.

thanks all

**Jon_Peltier** · 12-16-2015, 11:38 PM

How is Chart2Copy declared? If it's a chart, then it is either this for an embedded chart:

Set Chart2Copy = ActiveSheet.ChartObjects("STP% Chart").Chart

or one of these for a chart sheet:

Set Chart2Copy = ActiveSheet

Set Chart2Copy = ActiveWorkbook.Sheets("STP% Chart")

Set Chart2Copy = ActiveWorkbook.Charts("STP% Chart")

Select a chart from a chartsheet in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Re: Select a chart from a chartsheet in VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] There is an error if sheet is "ChartSheet."

[SOLVED] Delete Chartsheet

How do I add buttons on a chartsheet which controls the autofilter on the underlying data?

How do I add buttons on a chartsheet which controls the autofilter on the underlying data?

How to move the chartsheet(leaving the raw data sheet in the orig file) to a new file

RangeFromPoint ... on a chartsheet ?

[SOLVED] 1 ChartSheet, 10 worksheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions