Paste a range and shifting away existing data

Discussion in 'Excel Programming' started by, Apr 19, 2014.

  1. Guest


    I am looking a way for copying a range to an active cell such that all the data right to the active cell remain unaffected and move to the right accordingly to leave space to the new range

    , Apr 19, 2014
    1. Advertisements

  2. Auric__ Guest

    Shift first, then copy:

    ActiveCell.Insert Shift:=xlShiftToRight
    Cells(1, 1).Copy Destination:=ActiveCell

    (Replace Cells(1, 1) with the range actually being copied.)
    Auric__, Apr 20, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.