Forum Discussion
countblank in a range made up of smaller areas
FIle attached here, Hans, with further description of what is happening . . .
As I say within the file, the 'crash' occurs unpredictably, so, if you just edit different cells with different numbers, there seems a good chance that, while yuo are doing that, it WILL occur & you will see for yourself what it might be due to.
Sorry for delay.
Thanks again,
Vincent
I'm sorry, I have spent about 10 minutes ceaselessly entering, editing and deleting numbers in the puzzle cells. At no point did I get #VALUE!; the formulas returned the correct results all the time.
So I'm afraid I don't have an explanation, nor a solution.
It might be your laptop. I'm still not able to reproduce the error.
Hi, Hans,
Here's the file again, which I'll need to save to send to you, and, when you open it, the #Value! display will disappear, but I've taken some screenshots of the fact of the problem, for me. I've added notes on the main page as well. Thanks again for any help. And it's a great function, excellent!
VIncent K
I'll keep the workbook.
- Yes, I was afraid that would happen. Keep the file for now, if you would, & I might get back with a particular sequence that brings up this anomaly. Thanks again. VK
