Size of returned array from function

Question

You can use UBound to determine the size of an array. I want to that that to an array returned as a result of a function, but then I get the error Invalid procedure call. This is the (simplified) function:

Public Function GetCheckBlocks(fileName)
    Dim counter, checkBlocks
    Set checkBlocks = CreateObject( "System.Collections.ArrayList" )

    For counter = 0 To 10
      checkBlocks.Add counter
    Next

    Set GetCheckBlocks = checkBlocks
End Function

And here is the way I call the function and want to get the size of the array:

Dim expectedChecks, expectedFile
expectedFile = "test.txt"

Set expectedChecks = GetCheckBlocks(expectedFile)
MsgBox UBound(expectedChecks)

What is wrong here and how do I get the size of the returned array?

Jean-François Corbett · Accepted Answer · 2014-11-11 08:14:45Z

1

Your function returns an ArrayList object, not an array. UBound only works with arrays. To get the number of elements contained in an ArrayList, use the .Count property:

expectedChecks.Count

answered Nov 11, 2014 at 8:14

Jean-François Corbett

38.7k30 gold badges146 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ansgar Wiechers Over a year ago

Alternatively: have the function return checkBlocks.ToArray if you want/need a VBScript array.

Collectives™ on Stack Overflow

Size of returned array from function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related