Using VBA to make a chart

I have the following code to create a 3D line graph:

Please Login or Register  to view this content.

I want to re-use this for different graphs, but the range is never the same. What could I put in the Range command to tell it to select all the cells with the data for my different worksheets? Each worksheet only has the graph data and nothing else. Thanks!

Hi Rfedeleo,

Put this in the ThisWorkbook module, it should work:

Please Login or Register  to view this content.

Or, without declaring an object, simply use:

Please Login or Register  to view this content.