Returns an array from function vba

Function arrayOfPiDigits() As Long()

	'Add parenthesis after the data type
    Dim outputArray(0 To 2) As Long
    
    outputArray(0) = 3
    outputArray(1) = 1
    outputArray(2) = 4

    arrayOfPiDigits = outputArray
    
End Function

Source: riptutorial.com

Similar codes

0 vote217 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote236 views1 answer
Excel vba copy range with filter
VBA
3 votes233 views1 answer
Excel vba change format of cell
VBA
8 votes236 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote233 views1 answer
Vba string
VBA
0 vote218 views1 answer
Vba shape transparent
VBA
2 votes220 views1 answer
Vba round number
VBA
0 vote209 views1 answer
Excel vba milliseconds
VBA
2 votes254 views2 answers
Excel vba if sunday or staurday
VBA
-1 vote215 views1 answer
For i in range vba
VBA