VB Forum / General / February 2005

Have a look at the VarType() method.
Note; the vbArray value is a _flag_ as opposed to the other values which are discreet values, i.e. vbInteger = Integer,
vbInteger Or vbArray = Integer().
You can test for an array using "VarType(Array()) Or vbArray" or if you want to know the variable type regardless of
whether it's an array or not then use "VarType(Array()) And (Not vbArray)".
Also note that UDT's cannot be cast to a variant and as such if you have an array of UDT then you should know it's an
array of UDT's because you have to declare them that way...
Hope this helps,

   Mike

- Microsoft Visual Basic MVP -
E-Mail: EDais@mvps.org
WWW: Http://EDais.mvps.org/

And after actually _reading_ the question...  You can use LBound() and UBound() to get the size of each dimension of the
array, or use hack around with the array descriptor:
http://vbnet.mvps.org/code/helpers/getarraydims.htm
Hope this helps,

   Mike

- Microsoft Visual Basic MVP -
E-Mail: EDais@mvps.org
WWW: Http://EDais.mvps.org/