Thank you so much. Adding "application.enableevents=false" in the codes also
solve my problem.

But how do I know which event is back firing when I clear contents of a
spreadsheet?

"Dallman Ross" wrote:

In . com,
unclemuffin spake thusly:

I am using Excel 2007 and I have a sheet that has about 22,000 rows of
data. When I try to delete the data by all of ?
the following methods
it takes well over three minutes to complete:

Try going into Options / Calculation and switching it to manual
mode.

If that helps, you can turn calculation mode off in a macro that helps
you delete, then turn it back on.

=dman=