MrExcel Publishing
Your One Stop for Excel Tips & Solutions

saving an array when the user quites excel


Posted by Anna on November 11, 2000 2:36 AM

Hi All,

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?

please help,

regards

Anna Daly
e-mail:- annadaly@hotmail.com


Posted by Ivan Moala on November 11, 2000 3:52 AM


Anna
Some along the lines of this may help ??
5627.html
If not then.....post

Ivan