Consulting

Results 1 to 2 of 2

Thread: How to combine Selection. PasteSpecial and Selection.insert Shift in one VBA code ?

  1. #1
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location

    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

  2. #2
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location
    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
  •