ActiveX

To select multiple blocks of cells using code

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Call the SetSelection method to select the first block
3. Call the AddSelection method to add additional blocks.
4. Repeat step 2 until all blocks are selected.