I want to create a function in a module that will read an array from sheet1 preform an operation on it then return the result to the spreadsheet in a defined amount of cells in this example 8.
In Module1:
Code
Function func1(ByRef arrayA())
Dim arrayB(8)
For k = 0 To 7
arrayB(k + 1) = arrayA(k) * 2
Next k
func1 = arrayB
End Function
In sheet1:
The input is D3:K3, arrayA.
How does the resultant arrayB get populated onto the spreadsheet?