ActiveX
To swap formatted data between two blocks of cells
Swap the data using one of the following methods,
- To swap a range of columns, use the SwapColRange method.
- To swap a range of rows, use the SwapRowRange method.
- To swap a range of cells, use the SwapRange method.