VBA to create Graph

[bookworm121]

I'm trying to write code to add a graph based on data I have in a spreasheet
Unfortunately the data will sometimes span across 10 cells, but sometimes will will span across 15 or 20 or however many cells (Simply, i will have more data points).

I tried writing code like this:

Please Login or Register  to view this content.

But I get a "Object Variable or With block Variable Not Set" error on the 3rd line..

Any thoughts?

[Sbarro79]

You must use Set statement for GRange variable:

Please Login or Register  to view this content.