Paste a range and shifting away existing data

Discussion in 'Excel Programming' started by metricsinstitute@gmail.com, Apr 19, 2014.

  1. Guest

    Hello,

    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

    Avi
    Thanks
     
    , Apr 19, 2014
    #1
    1. Advertisements

  2. Auric__ Guest

    metricsinstitute wrote:

    > 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


    Shift first, then copy:

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

    (Replace Cells(1, 1) with the range actually being copied.)

    --
    Be not too eager to deal out death in the name of justice,
    fearing for your own safety. Even the wise cannot see all ends.
     
    Auric__, Apr 20, 2014
    #2
    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.