Do you have any worksheet events firing?

_selectionchange
_change
_deactivate
_activate

(remember to check for workbook level events, too.)

One of the bad things about running macros is that they sometimes kill the
clipboard.



Jack Sons wrote:

Hi all,

Suddenly paste (worksheet function as well as VBA) will work only on the
same sheet, so I can't copy anything to another sheet nor to another
workbook.

This is a real disaster.

Please help. I use XP SP2 with Excel 2k

Jack Sons
The Netherlands

--

Dave Peterson