Hi Dave,

Thanks for your suggestion, but no luck this time - the problem still occurs.

After some more playing around, I have noticed that this same problem does
not occur when copying and pasting data from other worksheets that contain
lots of formulas.

It seems that my problem is specific to the worksheet I am copying from (in
the example I gave before, this it the 'EventLog' worksheet), which makes me
less confident that someone else may have had this problem before.

I'll keep looking but any more help would definately be appreciated.

Cheers,

David