We can use VBA to Cut a Range to another Paste into Clipboard or other location or range. Range.Cut method will cut and it will save the data in the Clipboard then you can select any range and paste. You can also specify the destination range while cutting a range.
VBA to Cut Range in Excel – Syntax
Here is the syntax to cut a range using VBA. Here, Destination is the range which you want to be copied. This is optional, if you are not providing the destination range, this will copy to the Clipboard.