create array by using a function

[Certified]

I am getting a mismatch error at the line highlighted in red. The error occurs after the function is ran. I am confused because I created both items variants. How could there be a mismatch?

Option Explicit
Option Base 1
 
 
Dim theDict As New Scripting.dictionary


Sub Create_ownership()

    Dim capitalOwnerArray() As Variant       
    
    [COLOR=#ff0000][B]capitalOwnerArray = populateDict(capitalArraY)[/B][/COLOR]
    
End Sub

Function populateDict(thearraY As Variant) As Variant

Dim i As Integer

Dim key As Variant

Dim returnarray() As Variant

    For i = 1 To UBound(thearraY)
    
        If theDict.Exists(thearraY(i, 2)) Then
        
        theDict(thearraY(i, 2)) = theDict(thearraY(i, 2) + thearraY(i, 8))
        
        
        Else
        
        theDict.Add key:=thearraY(i, 2), Item:=thearraY(i, 8)
    
        End If
    
    Next i
    
  ReDim returnarray(UBound(thearraY), 2)
  
  Erase thearraY
    
     
   i = 1
    
    For Each key In theDict.Keys
          
              returnarray(i, 1) = key
              returnarray(i, 2) = theDict(key)
              i = i + 1
              
        Next key
        
    thearraY = returnarray
    
    
End Function

 

[RoryA]

What is capitalArraY and how is it populated?

 

[Certified]

What is capitalArraY and how is it populated?

I am trying to populate with the function.

[Function populateDict(thearraY As Variant) As Variant/CODE]

 

[Rick Rothstein]

What is capitalArraY and how is it populated?

In addition to RoryA's questions, I don't understand the construction of your function. You seem to have constructed it like a subroutine, not a function. As a last step in a function, you assign the return value or object to the function's name so that it assigned or used by whatever line of code called it... you are not doing that , instead, you assigned the return object back to the argument itself but then you try and get at that object via the function's name in the calling line of code... since you never assigned anything to the function's name, its value is Empty.

 

[Certified]

I am new a functions so maybe I guess I don't understand how to construct them.

I want to populate a array with data from a dictionary. I find arrays easier to work with.

I want to populate 5 arrays. Normally, I would write the same code 5 times for each array, but I read it would be more efficient if I used a function.