Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste a range and shifting away existing data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste a range and shifting away existing data
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
After Copy and Paste, Add to an Existing Named Range | Excel Programming | |||
Data From Excel Range To Existing Access Table | Excel Programming | |||
How do I paste to append instead of replace existing data? | Excel Discussion (Misc queries) | |||
Shifting Data Right Within A Range | Excel Programming |