SebastianColombia
New Member
- Joined
- Oct 21, 2013
- Messages
- 12
I have a tricky need in Excel, which I haven't been able to solve. I think it's quite complicated and I don't have enough knowledge about VBA codes.
. I would really appreciate if you could help me with this.!!!!!!
Basically what I'd like to do is to create a function. The input would be a RANGE with blank cells, and non blank cells. I would expect the function to COUNT 'SINGLE BLANK CELLS' as single "ranges" and CONTIGUOUS BLANK CELLS as single ranges too. I know it's kind of tricky, but I made a video.
https://www.youtube.com/watch?v=QGS8DBcA5HA&feature=youtu.be
Thanks a lot.
![frown.gif](/board/proxy.php?image=http%3A%2F%2Fwww.excelforum.com%2Fimages%2Fsmilies%2Ffrown.gif&hash=3329b5598c6b9da4fa16ab9cf0fcd9ac)
Basically what I'd like to do is to create a function. The input would be a RANGE with blank cells, and non blank cells. I would expect the function to COUNT 'SINGLE BLANK CELLS' as single "ranges" and CONTIGUOUS BLANK CELLS as single ranges too. I know it's kind of tricky, but I made a video.
https://www.youtube.com/watch?v=QGS8DBcA5HA&feature=youtu.be
Thanks a lot.