Swapping Selected Range of Cells with Another Selection

Complexity of code will depend on how flexible it has to be.

You'll need to give more detail than what you provided.

1. Are you only swapping values? Or do you need to swap formula, format, etc as well?
2. Is swapped range always going to have same dimension? (i.e. first range row & column count = second range row & column count). In another word, 1 to 1 swap.
3. Will it be always within same workbook and/or worksheet?

If it's values only and dimension is same between two ranges and only from same workbook... it will be fairly straight forward and simple code.
Otherwise, as you add more flexibility, more complex the code will be.

But really, this sort of flexible operation is best left out of VBA and done manually.
Simple key combo along with some blank sheet to store values will make swapping easy.

You may try something like this...

Please Login or Register  to view this content.

Let there be even more choice ... ... with pop-up menu ... (see additionally: https://msdn.microsoft.com/en-us/lib...fice.14).aspx)

Areas do not have to be equivalent, at most, strange things will come out of it.
Select two areas to swap and select the menu from the right mouse button - first position.

1. In 'ThisWorkbook' module:

Please Login or Register  to view this content.

2. In Standard module:

Please Login or Register  to view this content.