Example

The following example swaps the data of two blocks of cells—from B3 to B7 to the cell starting with D3.

C++

// Swap data in two blocks of cells
m_Spread1.SwapRange(2, 3, 2, 7, 4, 3);

Visual Basic

' data in two blocks of cells
fpSpread1.SwapRange 2, 3, 2, 7, 4, 3