-
How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ?
Hello,
I would like to know if there is a way to combine in only one vba code this two code? In fact, i would like to have the possibility to select ranges, copy and paste them without erase others ranges and also without copy the conditonal formats.
Sub
Selection.PasteSpecial Paste:=xlPasteAllMergingConditionalFormats, Operation _
:=xlNone, SkipBlanks:=False, Transpose:=False
End Sub
Sub
Selection.insert Shift:=xlDown
End Sub
Thanks a lot in advance,
Jfglrx
-
So, i assume that it's not possible to do it ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules