It will tell you how many cells in column A are not empty. (it counts how
many are no empty - it is using the excel worksheet function COUNTA as in

=COUNTA(A:A)



--
Regards,
Tom Ogilvy

mushy_peas wrote in message
...
i dont get this bit
application.worksheetfunction.counta(RAnge("A:A"))
could you pls explain, ta


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