Moving a range: move a range by cutting it to the Clipboard and then pasting it in another area
Sub MoveRange() Range("A1:C6").Select Selection.Cut Range("A10").Select ActiveSheet.Paste End Sub