Forum Discussion
countblank in a range made up of smaller areas
If you have a range of cells (call it MyRange) made up of smaller areas, so that MyRange is never just one 'rectangle' of cells but a few of them (which happen to be adjoining), I find that the funct...
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
I'll keep the workbook.
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
