Insert range function and CopyOrigin
 

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.

Insert range function and CopyOrigin -- addendum
 

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.

--

Vasant



"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.
.

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.
.

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.

Insert range function and CopyOrigin
 

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.


---
Message posted from http://www.ExcelForum.com/

Insert range function and CopyOrigin -- addendum
 

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. :)
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.

--

Vasant



"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.
.

Insert range function and CopyOrigin -- addendum
 

Ahh! Please disregard that. That is not correct.

--
Dana DeLouis
= = = = = = = = = = = = = = = = =

<snip

Insert range function and CopyOrigin -- addendum
 

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 ... ;)


---
Message posted from http://www.ExcelForum.com/