Hi all,

A bit of an update...

I have noticed that the worksheet I am copying and pasting has a very large
amount of formulas which link to another worksheet. I found that if I remove
these formulas, the problem is solved i.e. the looping copy/paste operation
from my first post does NOT slow down over time. This is great - this is what
I am after.

Therefore, it seems to me that if I copy and paste the worksheet when the
formulas are present, Excel tries to recreate the formula dependency tree or
something like that. Over time, this tree recreation process gets
progressively slower, despite that Application.Calculation is set to manual.

So, what I need now is some way of temporarily 'turning off' these formulas
during the copy/paste process. For example, I could rattle through the
worksheet and insert a character (e.g. '!') in front of the formulas,
essentially converting them to strings. Its just that this takes too long to
do (and then undo).

Is there any extremely quick way to stop this behaviour???

Please help!!!

David