![]() |
stuck in an error loop
I had created an array using the frequency function. I tried to delete the
last cell in my array. Alas, what a mistake. I got stuck with an error message that explained to me that changing an array was not acceptable. However, the undo function would not let me replace it with what I had. Excel locked up and whatever I clicked on just repeated the array error mistake. I had to use task manager to exit Excel and lost all that I had not previously saved. Was there some other option to exit from an error message? |
stuck in an error loop
If you simply selected the cell and tried to delete, the message would come
up and disallow the deletion so nothing would be changed. If you selected the cell and edited, then the message would pop up and you would have to re-edit then CSE again on that cell only. Gord Dibben MS Excel MVP On Fri, 8 Jan 2010 09:39:01 -0800, Darla wrote: I had created an array using the frequency function. I tried to delete the last cell in my array. Alas, what a mistake. I got stuck with an error message that explained to me that changing an array was not acceptable. However, the undo function would not let me replace it with what I had. Excel locked up and whatever I clicked on just repeated the array error mistake. I had to use task manager to exit Excel and lost all that I had not previously saved. Was there some other option to exit from an error message? |
All times are GMT +1. The time now is 12:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com