View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Insert range function and CopyOrigin -- addendum

Sub Tester3()
With Worksheets("Sheet1")
.Range("A10:F15").Copy
End With
With Worksheets("Sheet3")
.Range("F6").Insert xlShiftDown
End With
Application.CutCopyMode = False
End Sub

Not sure what copyorigin refers to.

--
Regards,
Tom Ogilvy

"David Lewis" wrote in message
...
I meant without using select/copy. That's klunkier and
frequently leaves the shimmering-dotted box on the
worksheet. (by the way, hHow do I get rid of that).

Thanks. --David.

-----Original Message-----
How does the CopyOrigin argument to the Insert function as
applied to ranges work?

Actually, how does the whole Range.Insert function work?
The documentation in help isn't too helpful, nor is the
book I'm using (Walkenbach)

What I want to do is insert in one worksheet a copy of a
range of rows from another sheet.

Thanks. --David.
.