One copy command for mulitple cells

[coopedup]

Hi all,

I have a speadsheet that updates various tables and graphs based on values in certain fields or selection of check boxes. The fields are user entered in a form attached with a macro.

Problem I have is that the Calculting time is quite long and by having what I've done below means it executes the calculations twice. Can I turn the below in to once Copy string?

Please Login or Register  to view this content.

[CK76]

Nope. You can't.

Have you tried setting Application.Calculation to xlCalculationManual at start of your code/process and then turning it back to xlCalculationAutomatic at end of your code/process?

To speed up code in general read link below.
http://www.cpearson.com/excel/optimize.htm

[coopedup]

I suspected that was the case, as I'd tried so many varients.

I'l try the xlCalculation and do a bit of home work reading.

Thanks!