how do count all record in one column
 

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

--
Message posted from http://www.ExcelForum.com

how do count all record in one column
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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


---
Message posted from http://www.ExcelForum.com/

how do count all record in one column
 

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

--
Regards,
Tom Ogilvy

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


---
Message posted from http://www.ExcelForum.com/