i HAVE THIS CODE BELOW
However I don't want it to copy instead I want it to cut however when I do this it goes wrong![]()
Sub datam() Sheets("Sheet1").Range("A1:D25").Copy Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial _ Paste:=xlPasteValues Application.CutCopyMode = False End Sub
![]()
Sheets("Sheet1").Range("A1:D25").Cut Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial _ Paste:=xlPasteValues Application.CutCopyMode = False
Bookmarks