The attached has worked very well - Excel 2010 in Windows 10
The attached sub routine loops through a list of sheets and for each sheet calls in the arguement also shown.
As the model has grown in size I have started to encounter the screen flickering as the macro jumps from one sheet to another - despite screnUpdating being false and also the run time has gone from 1 minute to 4 minutes
The net is awash with this problem and ideas on causes however the use of Select is commonly blamed
Ignorance on my part means that I cannot alter the use of Select in my code to see if the flickering stops.
I would appreciate if someone could give me guidance on how to circumvent the use of Select in this code