jfglrx
10-18-2017, 02:02 PM
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
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