Check you worksheet code modules for Worksheet_Change code, or any code in
the stanadard module or formulas in the worksheet cells that might trigger
from changes in the cells value and would recalculate.

"RCL2884" wrote:

When I use ClearContents in Excel 2003 I get a very slow response, when
clearing many rows. For example, if I clear about 30 columns and 30,000 rows,
it might take 10 minutes. If I run the same procedure

For example: Range("A1:AD30000").ClearContents

on a different computer, it takes less than a second. What is going on? I
have looked through all the settings, but do not see anything obvious.

I am using XP-Pro, with a 2.66 Mhz dual core Xeon processor, with 2 GB of
ram, and so the system should not be an issue. This problem began suddenly
several months ago and has persisted through a reinstall of Office 2003. It
is driving me crazy.

Thanks,
Rick