If the cells you are pasting the data into are referenced in formulas, the
slowness could be related to those cells updating (the ones with formulas).
To test this, you can set calculation updating to manual, run the macro and
see if performance improves (TOOLS - OPTIONS - Calculation - choose manual).

If this is the cause, change calculation back to manual, and add the
following to the beginning of your code:

Application.ScreenUpdating = False

This may or may not help.

Ken



" wrote:

Most of the macros literally select a range, copy it, then select a new range
and paste special-values. These are the majority of my macros and the ones
that are slowing down my workbook.

Thanks

Adam Bush

"Toppers" wrote:

Without seeing the w/book and associated macros it's not possible to advise
you on what to do to improve performance.

" wrote:

I have a large workbook with many buttons that run different macros. Mostly
these macros copy and paste infomation for backup, analysis, and later use.
I recently added a new feature that forced me to add many more of these
functions, and now when I push a button, the workbook moves unbearably slow.
Is there any way to speed up the running of these macros or is there a
different way I could set up the page so it doesn't have to copy and paste a
million times?

Thanks in Advance,

Adam Bush