dynamic range in chart source data

[sulley333]

Does anyone see a problem with this? I am getting a run time error that say application-defined or object-defined error.

    ActiveChart.SetSourceData Source:=Sheets("Comparison Analysis Data").Range( _
    Cells(5, 1), Cells(chartrow - 1, cnum + 1))

I tried naming a range and using that instead but couldn't get that to work either.

 

[sulley333]

Nevermind...I figured it out! Thanks anyways!

 

[pgc01]

Hi sulley333

I'm glad you figured it out.

When you find a solution it would be good to share it. Someone may have the same problem some time from now, will find this thread and won't have a solution.

In your case, it's just a syntax error, you could explain what was wrong with the code you posted and how you have corrected it.