View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default Number of elements in an array

I have some arrays dim'd in the declarations procedure that are accessed by
different macros.

at times I'm lazy and get tired of looking back to see the (1 to ??) value.

when I loop thru string vars, I often use: for x = 1 to len(varname)

Is there a similar statement or property for fixed length arrays?
I looked thru help on array, dim, etc. and could not find it.
maybe there's a way to use .count ?

Thanks.

--
Neal Z