Forum Discussion
Vincent Kelly
Aug 29, 2021Copper Contributor
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...
Vincent Kelly
Sep 08, 2021Copper Contributor
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
HansVogelaar
Sep 08, 2021MVP
It might be your laptop. I'm still not able to reproduce the error.