how do count all record in one column

ducmis · Apr 1, 2004

i know how to use counta function (e.g counta(F:F)) to find out all th
records in one column but how do you do this in vb. I am pretty sure
need to use .recordcount but i don't know how to . Please give me som
insights

Frank Kabel · Apr 1, 2004

Hi
you may use
application.worksheetfunction.counta(...)

Tom Ogilvy · Apr 1, 2004

var = Application.CountA(Range("F:F"))

i to = column in Formula	19	Apr 16, 2014
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A	2	May 20, 2016
count partial string in a range	2	Jan 15, 2009
Multiple Dynamic Named Ranges across Columns	3	Jul 31, 2012
Figuring out MAX LEN in a given column	2	May 12, 2010
Count Non Blank Rows	12	Apr 4, 2007
Defining a range in many sheets	6	Jan 2, 2009
How do you count specific values in a row	4	Sep 4, 2008

how do count all record in one column

ducmis

Frank Kabel

Tom Ogilvy

Ask a Question

Similar Threads