MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting Items in an Array


Posted by Bill Mahoney on February 14, 2002 9:20 AM

Hello, what is the proper syntax to find out how many entries are in an array.

for x = 0 to arrayName.Count

doesn't work. Any help wouldbe appreciated.

Regards,
Bill Mahoney
New York, NY


Posted by DK on February 14, 2002 9:43 AM

How about Ubound(ArrayName)?

D

Posted by Bill Mahoney on February 14, 2002 9:48 AM

Thanks for the help. This sight is a godsend.

Regards,
Bill Mahoney
New York, NY