ActiveX
To select multiple blocks of cells using code
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Call the SetSelection method to select the first block
- Call the AddSelection method to add additional blocks.
- Repeat step 2 until all blocks are selected.