Insert range function and CopyOrigin

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You get rid of the "marching ants" by using:

Application.CutCopyMode = False

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 ... unless you
just want to copy values, in which case you could use something like:

rngDestination.Value = rngSource.Value

But I don't think that's what you're looking for.
 
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.
 
-----Original Message-----
You get rid of the "marching ants" by using:

Application.CutCopyMode = False
Click to expand...

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
Click to expand...

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

--David.
 
Why not just use Copy & Paste ? You can record a macro of your actions
and come back with a new message if you have problems.
 
I believe "CopyOrigin" makes multiple copies of the Origin to fill the
destination. Here is a small demo.

Sub Demo()
[D1] = "Hello"
[D2] = "There"

[D1:D2].Copy
[A1:A10].Insert Shift:=xlShiftDown, CopyOrigin:=True
Application.CutCopyMode = False
End Sub

HTH. :>)
 
There is one use for CopyOrigin ... telling the insert whether to use
the formatting above/below/left/right of the inserted text. The only
value I've seen is xlFormatFromRightOrBelow ... Left/Above is the
default. In fact, that's how I found this thread is searching for a
list of possible values ... not many mentions of this ... had to resort
to recording a macro to figure out the right value for copying from
below ... ;)
 
Back
Top