Hi,

I have a very simple button on an excel spreadsheet designed to move a chunk of data from one area of a worksheet to another, and then clear the contents of the area where the data was before. The problem is that every time it executes, Excel doesn't respond for at least 15 seconds afterward. It's very annoying, and I wonder if someone can help me out. I've posted the code below. I'm running excel 2k7 on a Dell Precision490, so processing power isn't a problem at all. The excel freeze does not happen when i manually delete the data using the 'delete' key! Very confusing.

Application.ScreenUpdating = False


        Range("C7:P20000").Select
                Selection.Copy
        Range("R7").Select
                Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
                    False, Transpose:=False
        Range("C7:I20000").Select
            Selection.ClearContents

Application.ScreenUpdating = True