Count function

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.

try this

Please Login or Register  to view this content.

Originally Posted by YasserKhalil

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

Originally Posted by gondal

try this

Please Login or Register  to view this content.

Same with this code. 500 returns

can you upload the sheet..??

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.

Please Login or Register  to view this content.