Returning the size of an array?

[elziko]

I have a function that ReDims an array. I then want to use the array in another function so I need to find, in some way, the size of this array.

Cant find anything in help.

Any ideas?

Cheers elziko

 

[Ruairi]

UBound(ArrayName) will return the highest index number in the array. LBound(ArrayName) returns the starting index. Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications

 

[rvBasic]

Have a look at:

http://www.vb2themax.com/Item.asp?PageID=CodeBank&Cat=130&ID=271

This page posts a function that returns the dimensions as well as the bounds of arrays

NOTE: This editor inserts a colon [;] into the URL. No matter how hard i tried to avoid it, it always showed up! Sorry

 

[culshaja]

If you are using the UBound and LBound functions you need to use them as follows:

intSize = (UBound(arrMyArray) - LBound(arrMyArray)) + 1

If you don't add one to the result you will get an array size back one to small!

james James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305