I'm wondering if someone could help with what may or may not be a simple request.


I'd like to be able to swap a Range of Selected Cells with another Selected Range.

For example; Select Range B5:B7 and then also F9:F11 And then swap the values in those cells/range.

The columns and rows is not fixed, so I would be swapping these selected ranges throughout the document.


Thanks