CountBlank cells skipping Columns

[sintek]

Hi All

I have been trying to find a solution to this problem for a while now and just can't get it...This code code counts blank cells in a range...

Please Login or Register  to view this content.

How can i amend the code to only count blanks in certain columns i.e B:D,H,J:K
I tried this but only allows for two entries?

Please Login or Register  to view this content.

pertains to a post currently active which is not getting any joy from other members...https://www.excelforum.com/excel-pro...ml#post4641633

[sintek]

Anyone out there able to assist...Just can't figure this out...

[sintek]

Ended up having to set individual ranges and add them together....Any other solutions...

Please Login or Register  to view this content.

[sintek]

Anyone out there able to offer an alternate solution?

[TMS]

I would suggest you have a look at Union and/or Intersect, maybe a combination of both.

[sintek]

Thanks Trevor

Will look into it and see if i can come up with code to replace above...

[sintek]

Nope, Right over my head...Just don't get it....

[xlnitwit]

Hi,

You might use one of these to create a multiple cell range

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

However, Countblank will not work with a discontiguous range so your current solution is fine. (You might also look at specialcells.)

[sintek]

thanks xlnitwit

just what i was trying to understand.

[karedog]

Unlike other Excel functions like AVERAGE(), COUNTA(), the COUNTBLANK() function does not support paramarray parameter (only one parameter is allowed), this will make the function cannot accept separated (union of) ranges.
https://support.office.com/en-us/art...6-24af6bd3ac22
https://support.office.com/en-us/art...2-53f3219e2509
https://support.office.com/en-us/art...b-8f33eb960cf6

As a work around, you can make an UDF that accepts paramarray parameters, and summing the CountBlank() result for each parameter, like this :

Please Login or Register  to view this content.

[sintek]

That's excellent karedog....thanks

[karedog]

You are welcome, thanks for the reps.

Regards