I have a workbook with cells on Sheet1 paste-linked to cells on
Sheet2.
Using a command button I need to be able to shift by one cell the
cells on Sheet1.
For example, if cell B3 is selected, I would click the command button
and cut cell B3 and insert it between cell B1 and B2, shifting the
other cells to the right, as shown below:
Private Sub CommandButton4_Click()
'move left
Selection.Cut
ActiveCell.Offset(0, -1).Range("A1").Select
Selection.Insert Shift:=xlToRight
End Sub
But when I do this, the paste-link formulas on Sheet2 move as well.
I need the cells on Sheet 2 to remain linked to where they were
originally. Is this possible?
Thanks!