Revision to remove flickering when importing data:

Hello Excel gurus:

I have this working code for importing data from one workbook to another workbook. During the process, the screen is displaying the worksheet that is being imported. In short, the display flickers and strange. Can someone revise the code below to remove the flicker and just a blank display or a progress message?

Thank you in advance.

Please Login or Register  to view this content.

Add these lines at the bottom and top

Please Login or Register  to view this content.

Thank you for your quick response. I added one star to your reputation.

Gemini528,
You are welcome!