• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Move the contents of a cell X rows/columns

Hi @Weldon

If your cell is H3, With VBA (Press Alt + F11 - Insert - Module) and put this code:
Code:
Sub MoveCell()
    With Range("H3")
        .Cut .Offset(7, 7) ' 7 Rows down and 7 Columns right
        ' .Cut .Offset(7, -7) ' 7 Rows down and 7 Columns left
    End With
End Sub

Please comment! Blessings!
 
Hi @Weldon

If your cell is H3, With VBA (Press Alt + F11 - Insert - Module) and put this code:
Code:
Sub MoveCell()
    With Range("H3")
        .Cut .Offset(7, 7) ' 7 Rows down and 7 Columns right
        ' .Cut .Offset(7, -7) ' 7 Rows down and 7 Columns left
    End With
End Sub

Please comment! Blessings!
Where I am deeply grateful, this is above my head. I do not know how to use VBA. I have tried in the past. Again,
 
Where I am deeply grateful, this is above my head. I do not know how to use VBA. I have tried in the past. Again,
I just managed to make your suggestion work. I have a number of cells that I have to cut the contents and move down 7 and right 7
 
Back
Top