saving an array when the user quites excel
Posted by Anna on November 11, 2000 2:36 AM
I have a spreadsheet that contains several forms. Each form contains several input boxes for the user. The entries put into these boxes are saved to an array.
At the moment when the user exits Excel the individual values contained in the array are copied to an individual cell in a workbook. This is quite a slow process.
Is there any way of saving the values of an array without copying them to cells when the user exits and saves excel?
ie can an entire array be saved to just one varient and then that single varient saved in a cell?