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 vote184 views1 answer
Vba listbox remove all items
VBA
0 vote164 views1 answer
Excel vba disable screen update
VBA
3 votes184 views1 answer
Extract the nth word from a text string
VBA
32 votes347 views2 answers
Excel vba column letter
VBA
0 vote191 views1 answer
Vbscript check if string contains
VBA
0 vote178 views1 answer
Dynamic array vba
VBA
0 vote183 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
8 votes291 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote195 views1 answer
VBA
VBA
8 votes330 views1 answer
Vba convert 2 bytes to an integer
VBA