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?

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?