VBA chart routine momentarily opens new sheet and displays 1st chart before adding 2n

VBA project extracts data from web, displays it on sheet and then creates a chart from the data. Command button gets additional parameters from a form, adds data to the sheet, deletes all chart objects, and creates two charts side by side. Problem: before displaying charts, the routine opens a new sheet, displays an empty chart object (initial run) or the previously created chart (2nd run), then closes the sheet. Very distracting to the user. I'm stumped! Help will be appreciated. Here's the chart sub from Module 1.

Please Login or Register  to view this content.

You will probably be asked by the moderators to add CODE tags to your code before any provides an answer to your question.

When you do that there is a very quick and simple solution to the problem.

Regards

This should do it ...

Please Login or Register  to view this content.

Regards