So I'm currently trying to get a count of the number of filled cells in a column in an excel sheet, but I'm unsure as to how to do that. I've seen things like:
Range("A1").End(xlDown).Row
but that doesn't give an actual count. Does anyone know how to get an integer valued count? Are there any methods built into excel for that purpose?
Thanks in advance.
The counta function could work.
'If the data is in column A
Dim lngCount as Long
lngCount = Application.WorksheetFunction.CountA(Columns(1))
msgbox lngCount
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments