ActiveX

To save data to an array

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 GetArray method and set the parameters as follows:
   1. Specify the top, leftmost cell that contains data you want to save with the ColLeft and RowTop parameters.
   2. Specify the array name with the VarArray parameter.