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/