View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cesar Zapata[_2_] Cesar Zapata[_2_] is offline
external usenet poster
 
Posts: 66
Default Processing Overhead during Cut/Insert




you can try to copy and destination then clearcontents instead of cut
and paste


for example

Sub test()
Range("a1:a10").Copy Destination:=Range("b1:b10")
Range("a1:a10").ClearContents

End Sub


Post your code may be there is something else slowing it.


Cesar Zapata

Phil Kenchatt wrote:

I have some code that I would like to optimise because it can run
quite slowly;

In a procedure that involves numerous Cut & Insert operations is there
a greater processing overhead if one references the EntireRow as
opposed to a Range.

I would be grateful for any comments

Kind Regards
Phil