Hi Rick,

On my systems ( with 5 versions of XL installed) I get the following results

With Enable events switched ON:
XL97 Very fast
XL2000 Slow
XL2002 Slower
XL2003 Even slower
XL2007 Over 3 Minutes

This happens with Clear, ClearContents, and Delete

With EnableEvents switched OFF all versions are very fast.

On Saturday we tested this on a system (XL 2003 only & Win XP SP2) that did
not have the latest updates and it was fast.

Since your system does not have XL2007 installed I think we can narrow it
down to some fairly recent update.

regards
Charles
_________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

wrote in message
...
On Dec 1, 4:47 pm, "Charles Williams"
wrote:
Hi Rick,

Do you have Excel 2007 installed?
If you do not have it installed then I think its something to do with
updating the system with Microsoft Update.


Nope... I am using Excel 2003 that has been fully updated. When the
problem first occurred a couple of months ago, I thought it might be
due to a recently installed update, and so I backed out the update,
but to no effect. I also reinstalled Excel 2003, and this did not
help. I will stop perseverating on this since I have a work-around. I
just wish I understood what is happening.
...Rick