View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
David Lewis David Lewis is offline
external usenet poster
 
Posts: 2
Default Insert range function and CopyOrigin -- addendum


-----Original Message-----
You get rid of the "marching ants" by using:

Application.CutCopyMode = False


Ah, thanks! That makes cutting and copying quite a bit
more attractive.

CopyOrigin seems to be a nonfunctional feature. I don't

think there is a way
of inserting a range without actually cutting or copying it


Yep, was about to draw the same conclusion myself. Seems
like an odd omission.

--David.