Library Reference?

[Otacustes]

Hi,

I am trying to find the upper limit of an array in Excel VBA 2003 but I cannot find it in the object explorer nor can autocomplete find it, so I am guessing that there is a missing reference to it's library maybe???

If anyone may know what the problem is or where I can find the missing function I would be very greatfull.

Thanks


All help is greatly appreciated
Kind regards
Ota

 

[SkipVought]

Hi,

Arrays are not objects. Check out the UBound function in VB Help.

Skip,

_[red][/red]