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