VBA worksheetfunction CountA

[normpam]

I've read that a worksheetfunction.CountA will return the number of non-blank cells, but how to use the number of non-blank cells? I've tried using a 'MsgBox' to test it, but with no success. How would the VBA look to return the number of non-blank cells?

Thanks....

 

[FormR]

Hi, for example:

MsgBox WorksheetFunction.CountA(Range("A1:A100"))

 

[normpam]

Thanks... funny, I thought I tried that before... guess I missed something in the syntax!

 

[pgc01]

Hi

I've read that a worksheetfunction.CountA will return the number of non-blank cells, ...

Hi

Just a remark: be careful with the word blank (bad word). CountA will return the number of non-empty cells. If you have a cell with a formula that return "" (empty string) CountA will count it.