I am trying to count a range for blank cells using CountBlank(), however, the range I need to use is, for example, "A:A".
When I specify an entire column, however, I get a massive number of blank cells.

Is there a way to tell CountBlank to only return the number of blanks that have data in adjacent columns?

This is an issue because sometimes I need to count A1:A234 but another day my data my span from A1:A500 for example.

Thanks!