Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert range function and CopyOrigin -- addendum
Ahh! Please disregard that. That is not correct.
-- Dana DeLouis = = = = = = = = = = = = = = = = = <snip |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO i INSERT A RANGE OF SERIAL DATES IN THE WORKDAY FUNCTION | Excel Worksheet Functions | |||
Insert range of cells with a function | Excel Worksheet Functions | |||
How do I insert a calculated cell range into an excel function | Excel Worksheet Functions | |||
Insert SUM function for range | Excel Programming | |||
expression.Insert(Shift, CopyOrigin) ? | Excel Programming |