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?

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.
Similar Threads
  1. Dan

    Shifting Data Right Within A Range

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

    Shifting data down

    morry, Feb 18, 2004, in forum: Excel Programming
    Replies:
    2
    Views:
    106
    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:
    616
    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:
    629
    adetaylor
    Jun 4, 2004
  5. Carroll

    Columns Shifting on Import of Data

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

    shifting data in excel (logs)

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