Macro to update chart using dynamic named range

I have the below line in a macro and it updates the series range of a chart as expected:

Please Login or Register  to view this content.

However, if I amend it to the below to have the chart update from a named range, I get an error (Run-time error 1004 - Application-defined or object-defined error):

Please Login or Register  to view this content.

For info, the named range is dynamic and if defined using the below:

Formula:

Please Login or Register  to view this content.

If the named range referrs to a static range (i.e. A6:D21) then the second line works fine so I'm guessing it's all to do with the dynamic aspect.

I need it to be a dynamic range as an earlier part of the macro adds/removes rows and data from the range that drives the chart.

Any ideas to get around this?

Try defining the named range using the below formula:

Formula:

Please Login or Register  to view this content.

Does that work for you?

BSB

It works!!! Thank you thank you thank you, BSB!

Now does anyone have any idea why the dynamic range with INDEX didn't work for this?