My procedures take too long to run...

Hi,
I have a couple of procedures that work, but they take a long time to run, and I was wondering if you can suggest ways to make them more efficient (which could be a complete change of approach)? The reason I ask is because I want to get better at writing efficient code. I've pretty much copied the code and adapted it so I'm sure it could be better. I'm happy to send out the workbook or provide further explanation if it would help.

The first sub "copysheets()" brings worksheets in from another workbook based on a list of sheet names. The second sub populates the imported sheets with formulae.

Here they are:

Please Login or Register  to view this content.

Thanks very much.

Thanks Norrie - I'd only switched off screen updating and missed the others. I'll give that a try.

Sorry - I meant thanks Norie

And then realised I could have just edited my reply...