help desperate, array not found in excel
Posted by Rob on December 31, 2001 10:44 AM
I have a large spreadsheet in which I want to insert new rows. I use quite a few arrays with linked worksheets.
I now have a problem whereby excel will not permit a row to be inserted. It gives message "you cannot change part of an array" When I use the goto, special, current array command, to find the extend of the array, excel indicates that no array is found.
Any ideas folks? Is spreadsheet or workbook corrupted perhaps? I'm desperate. It took me years to develop this workbook.