Setting a data range for a chart (error 1004).

Hi
I'm trying to do a simple loop which creates charts based on an ID number. I recorded a macro and has tried to modify it but am having trouble defining the correct reange when settign the data source.

Here is my code:

Please Login or Register  to view this content.

This results at a run time error 1004.
Any help debugging this would be appreciated.

Hi HammerTime,

I don't think you can use the cells method when setting the source area for a chart. See how this goes:

Please Login or Register  to view this content.

HTH

Robert

You need to fully qualify the references.

Please Login or Register  to view this content.