Quick CountA question

[crugg]

Hello -

How would you write the code to set a variable (integer) to the number of rows that contain data/text in a sheet?

I cant use specialcells/LastCell for various reasons. Has to be CountA or some other solution that I dont know of.

Thanks!

[Bob Phillips]

[vba]

myVar = Application.CountA(Columns("A"))
[/vba]

[chungtinhlak]

Counta will only count non blank cell, is it all data or just text data?