Paste a range and shifting away existing data

M

metricsinstitute

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
 
A

Auric__

metricsinstitute said:
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
Click to expand...

Shift first, then copy:

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

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

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a cell into bookmarked table from excel vba 1
Creating Network Diagram using a Chart SW integration 0
copy a 2 dimensional array to a range 2
active row copy into Outlook 0
Create if partial match then copy and paste data from one cell to another 1
Count no empty cells at the right of a selection 2
How to modify and updte specific styles for specific paragraphs across the document 0
Linking data in MS Word into Excel 5

Top