VBA Not Copying Dynamic Graph Range When Importing CSV

[scotboy15]

Hi All,

Hoping someone can help me.

During isolation I've got some spare time and have created an Excel workbook with a macro that when a button is pressed it will allow the user to select a CSV file. The Macro then creates a copy of a "Template" work sheet which contains a Graph that contains dynamic ranges. The import of the CSV works correctly and everything appears fine except the dynamic range of the graph isn't copied across and it reverts to static references. The OFFSET function and things copys across is the name manager but the graphs dynamic range reference does not.

I've been trying this for a huge amount of time and not getting anywhere but am sure it is childs play for some of you Excel/VBA experts.

I have attached the current speadsheet and an example CSV file to load.

[AshNyu]

Hi,
I tested your file and in my case dynamic range of the graph WAS COPIED! But graph wasn't displayed because of wrong datatype.
So you should replace point symbol on comma symbol in your data values to solve this problem.

[scotboy15]

Hey,

Thanks for the reply.

Not sure why yours worked and mine isn't then. When I do it a graph is produced but ti doesn't use the dynamic range like the template one did. See image.

I'm not sure what you mean by "you should replace point symbol on comma symbol in your data values to solve this problem" - can you clarify for me please?

Attachment 668045

[AlphaFrog]

Add this to the end of your ImportCSV procedure

Please Login or Register  to view this content.

[scotboy15]

Add this to the end of your ImportCSV procedure

Please Login or Register  to view this content.

Seriously, you are an absolute legend - that worked perfectly. Words can't even begin to describe how grateful I am for that. Thanks so much for your help