Thread: Array Size
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Array Size

SSR,

Use something like

NumElements = UBound(Arr) - LBound(Arr) + 1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Srinath" wrote in message
...
Hello again,

How can i get the Size of the Array ? that is I have an Array

which is
dynamic and at the end i would like to know the number of

elements in the
array and then do further processing.

Regards,
SSR