Error 1004

[Joachimjr]

Hello,

This is my code:

Please Login or Register  to view this content.

It creates the correct chart but gives me the 1004 error and says "The Specified Dimension is not valid for the current chart type.". How come the code works but still gives me that error? I know it has something to do with the Range variable. Is there something else I should write instead of "ActiveCells"? What I want it to do is to create the chart when I press ctrl+Q from the cells that I've selected


Thanks in advance,
Joachim

[Olly]

Try changing last line to

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Joachimjr]

When I try Source:=Selection, I get error 13 saying "Type mismatch". But the code still works. This is very strange :p

[Joachimjr]

And with Source:=Range("ActiveCells") I get the same error as I started with (I tried removing selection before I posted on this forum).

[Olly]

Do you actually need that line in at all? It's already created the chart based on the active selection...

[Andy Pope]

Is "ActiveCells" and named range or are you trying to code for the currently selected cells?

If it's the currently selected cells then you will have problems as the Selection change to a chart object when you add chart and select it.

I don't see AddChart2 as a valid method in xl2010. So either you have xl2013 or that is a typo.

[Joachimjr]

Using xl2013 on this computer (Was using 2010 when I created the account on a different computer). I'm trying to create a chart from the currently selected cells.

[Andy Pope]

I can not test AddChart2 at work. but code prior to change worked in xl2010.

Please Login or Register  to view this content.

As Olly says the newly added chart should use the selected cells as data source.

[Joachimjr]

Thank you Andy! Worked out perfect.