VBA For updating chart date range based on cell value

[Jennifer25]

The below macro is one I have used for a report I run to auto run through all charts in the report and update the date range based on 2 cell values
This used to run perfectly, now when i attempt to run this it is coming up with the below error message advising the min & max axes has failed

Why would this be and how can I fix this?

Thanks

Jennifer

 

[ashakantasharma]

Run-time error-2147467259 (80004005) when you set a property of a chart - Microsoft 365 Apps

Describes a problem in which you receive a run-time error message when you programmatically set a property of a chart in Excel. Provides a workaround for this problem.

docs.microsoft.com