ActiveX

To work with a block of cells

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col and Col2 properties.
3. Set the Row and Row2 properties.
4. Set the BlockMode property to True.
5. Set the properties to accomplish your task.
6. Set the BlockMode property back to False.