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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dan

    Shifting Data Right Within A Range

    Dan, Feb 16, 2004, in forum: Excel Programming
    Replies:
    2
    Views:
    124
    Tom Ogilvy
    Feb 16, 2004
  2. morry

    Shifting data down

    morry, Feb 18, 2004, in forum: Excel Programming
    Replies:
    2
    Views:
    93
    morry
    Feb 20, 2004
  3. Daniel M

    macro for shifting/combining and arranging data

    Daniel M, May 31, 2004, in forum: Excel Programming
    Replies:
    3
    Views:
    603
    Daniel M
    Jun 2, 2004
  4. Daniel M

    macro for shifting/combining and arranging data

    Daniel M, Jun 4, 2004, in forum: Excel Programming
    Replies:
    1
    Views:
    610
    adetaylor
    Jun 4, 2004
  5. Carroll

    Columns Shifting on Import of Data

    Carroll, Jan 14, 2005, in forum: Excel Programming
    Replies:
    1
    Views:
    198
    Carroll
    Jan 14, 2005
  6. mr_chrisevans

    shifting data in excel (logs)

    mr_chrisevans, Jan 10, 2006, in forum: Excel Programming
    Replies:
    0
    Views:
    69
    mr_chrisevans
    Jan 10, 2006
  7. nj
    Replies:
    2
    Views:
    113
    Tom Ogilvy
    Sep 19, 2006
  8. Aria
    Replies:
    4
    Views:
    119
Loading...