Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the CopyOrigin parameter for in the Excel VBA insert metho
Any suggestions?
-- Philip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What is the CopyOrigin parameter for in the Excel VBA insert metho
Philip,
I found some Google Groups threads with the same question. The second one hit paydirt. Here is the answer from somebody known only as "djh63." "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 ... ;) " I tried it with this bit of code, and djh63 is right: Rows("2:2").Insert CopyOrigin:=xlFormatFromRightOrBelow hth, Doug "Philip_plf" wrote in message ... Any suggestions? -- Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Getting "Too many different cell formats" error - utility or metho | Excel Discussion (Misc queries) | |||
capitalization rate mortgage equity analysis formula ellwood metho | Excel Programming | |||
Insert range function and CopyOrigin | Excel Programming | |||
expression.Insert(Shift, CopyOrigin) ? | Excel Programming |