title: Array Size Returned by Split Function - Excel VBA
body: <p>Here is what I have done so far.</p>
  
  <pre><code>Sub MP_division()
  
  Worksheets(3).Activate    
  Dim last_cell As Integer    
  Dim platforms() As String    
  Dim arr_size As Integer  
  
  platforms = Split(Cells(2, 47), ", ")    
  last_cell = Mid(Range("A1048576").End(xlUp).Address, 4)    
  arr_size = len(platforms) // is there something like this?    
  For x = 1 To last_cell    
      For y = 1 To arr_size 
          //do something        
      Next        
  Next   
  End Sub
  </code></pre>
  
  <p>My question is, how may I get the array size(arr_size) that is returned by the split function, so that I could use in my for loop? Thank you.</p>