Home > How-To Library > Arrays, Collections, Lists

How to find out the number of items in the collection

****************************************************************
*       © 2007 CodeItBetter http://www.codeitbetter.com        *
*          This notice MUST stay intact for legal use          *
****************************************************************

' Retrieve the last item in the EmployeeNames collection.
' Note that collections are one-based.
Debug.Print EmployeeNames.Item(EmployeeNames.count)

If you would like to submit your code here please us. Do not forget to mention your name. We are always thankful to each and everyone of you who submitted their code here.