Getting Chart DataRange

[AccessShell]

I created a line chart based on data from another tab in the spreadsheet. I ran 'Record New Macro' from the tools tab tp get code to expand the DataRange.
That was fairly simple.
But, what I need is to get the value of the DataRange already in the chart. I want to change the datarange from code. The last point on the graph is usually well before the datarange for the chart.
I need to compare the datarange in the chart with the last point in the chart to decide if I need to (in code) expand the datarange.

I can easily convert Excel VBA to VB6

I hope this is clear.

NOTE: This was posted, with different wording, in another forum.

Thanks

 

[AccessShell]

JP. I very slightly modified your VBA code and successfully replaced the row number (originally is was 1102) with a new number 1200. The update worked correctly. Now I have to convert the VBA code to VB6.

Thanks