On Aug 14, 7:07 pm, Dave Peterson wrote:
Any chance that your worksheet has an event that's firing?

It try this:
Open your workbook
Hit Alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.enableevents = false

Then back to excel to test the speed.

After it's done (good or bad), you'll want to enableevents again:
Hit Alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
application.enableevents = True

If that doesn't work, how about selecting smaller ranges and doing the clear in
little pieces.

unclemuffinwrote:

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:

Highlight the data range and press the delete key
Highlight the data range and click Home, Clear, All or Home, Clear,
Contents
Hightlight the rows and press delete key of right click and delete
rows

How can I speed this up?

Brent

--

Dave Peterson

That did the trick and solved my problem. How do I determine which
event is firing?