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/