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.