ActiveX
To work with a block of cells
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col and Col2 properties.
- Set the Row and Row2 properties.
- Set the BlockMode property to True.
- Set the properties to accomplish your task.
- Set the BlockMode property back to False.