think right about objects: here, columns

[weav8060]

in a few quick words, how am I thinking wrong when I use
Application.CountA(ActiveCell.EntireColumn.select)
to return the incorrect number of 1, versus
Application.CountA(ActiveCell.EntireColumn)
to returna the correct count of 109 in my particular spreadsheet?

I know I don't need to select a range to analyze it, but what is VBA's perspective?
many thanks
Stephan

 

[RoryA]

Select is a function that returns True if it succeeds, or False otherwise. So your first version is actually:

Application.CountA(True)

which is why it returns 1.