本帖最后由 FF7 于 2011-8-13 12:57 编辑
肯定是用数组快咯,大约2秒钟运行完!!
Sub 清空()
Dim i As Long, J As Long
Application.ScreenUpdating = False
Row1 = Range("C65536").End(xlUp).Row
ROW2 = Range("D65536").End(xlUp).Row
Dim arr, brr
arr = Range("C7:C" & Row1)
brr = Range("I7:I" & Row1)
For i = 1 To UBound(arr)
If arr(i, 1) = "RE" Then brr(i, 1) = ""
Next i
[i7].Resize(UBound(brr)) = brr
Application.ScreenUpdating = True
End Sub