Updating Line Chart with Named Range

Hi All,

I've been banging my head against the wall trying to finish off this small detail on part of a much larger macro. I have data on Sheet1 and a line chart ("Chart 1") on Sheet2. As the macro moves throughout the data on Sheet1 it updates a named range called "MyRange". The idea is to have the existing line chart on Sheet2 use use "MyRange" as it's data range (it contains both X and Y axis values). No matter what I've done I cannot get the chart to adopt this named range. When I tried recording excel does not capture that part of the process.

Can someone please help and advise on how I can get the line chart to use "MyRange" as its data range? I have left a code snippet below that is the jist of what I'm trying for.

Thank you in advance for any help you can provide

Please Login or Register  to view this content.

Hi

does this work:

Please Login or Register  to view this content.

I'm getting a 'method range of object global' failed on that line. Any suggestions on how I can amend this?

Thank you

Hi
does your workbook include a range named "MyRange"? if not, the macro will fail