Count function

[BryceVBA]

Hello, I need to count how many cells have entries in column A. I have the following code so far, but the variable is returning 17 instead of the 2 entries that actually exist. Does anyone know a more reliable count function that wont include blanks?

Please Login or Register  to view this content.

[YasserKhalil]

May be you have some cells with space in them " " so try this

Please Login or Register  to view this content.

[gondal]

try this

Please Login or Register  to view this content.

[BryceVBA]

May be you have some cells with space in them " " so try this

Please Login or Register  to view this content.

This code gave me 500 returns instead of 17. haha

[BryceVBA]

try this

Please Login or Register  to view this content.

Same with this code. 500 returns

[gondal]

can you upload the sheet..??

[MarvinP]

Hi Bryce,

You could also have a formula in a cell that returns a blank. This would look like a blank cell but be counted in the CountA function.

https://www.thoughtco.com/counting-a...f-data-3123571

[BryceVBA]

So instead of looking in the whole column, I limited the search to A1:A10, since this variable shouldn't have too many entries.

Please Login or Register  to view this content.

Also I owe you both an apology. I was originally using your code with a report that the code isn't compatible with yet, so the results were invalid. I tried both of your codes again with compatible reports and they both returned 17 still.

[Phuocam]

Please Login or Register  to view this content.