stuck in an error loop

  • Thread starter Thread starter Darla
  • Start date Start date
D

Darla

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

stuck in loop 6
Need to return an array 3
Unique values in an array. 2
Search for reference in an array 4
Functions/arrays 3
Loop required to merge worksheet data 2
multiple polynomial regression in Excel 4
Array function does not seem to work 19

Back
Top