Microsoft Office Forums - View Single Post - [Solved] Shift Excel Cell after executing a macro for second time

charlesdh · 01-08-2015, 02:54 PM

HI,

Have the file Destination go to another part of the sheet and then you copy the data to "A1" and have it insert the copied data and at the same time move the file down.
This is a recorded macro. But it may help.

Code:

Sub Macro3()
    Range("H1:H3").Copy
    Range("A1").Select
    Selection.Insert Shift:=xlDown
    Application.CutCopyMode = False
End Sub