Using FormulaArray in VBA

I need to write a function the sums two arrays and return an array as a result. This has to be made using FormulaArray. I've tried some thing as showed below, but doesn't work.

Function FFF(MinhaSelecao1 As Range, MinhaSelecao2 As Range) As Range

FFF.ArrayFormula = "=" & MinhaSelecao1 & "+" & MinhaSelecao2

End Function

Does anyone can help me?

FormulaArray is for entering an Arrayformula in a Worksheet.

Closest you could get would be

Function FFF(MinhaSelecao1 As Range, MinhaSelecao2 As Range) As Variant
FFF = Evaluate( MinhaSelecao1.Address & "+" & MinhaSelecao2.Address)
End Function


otherwise

Function FFF(MinhaSelecao1 As Range, MinhaSelecao2 As Range) As Variant
Dim v as Variant
v1 = MinhaSelecao1.Value
v2 = MinhaSelecao2.Value

for i = to 1 to ubound(v1,1)
v1(i,1) = v1(i,1) + v2(i,1)
Next
FFF = v1
End Function

This would give you a return array of the same size as the ranges passed in.

--
Regards,
Tom Ogilvy


"marcelobf" <[email protected]> wrote in
message news:[email protected]...
>
> I need to write a function the sums two arrays and return an array as a
> result. This has to be made using FormulaArray. I've tried some thing
> as showed below, but doesn't work.
>
> -Function FFF(MinhaSelecao1 As Range, MinhaSelecao2 As Range) As Range
>
> FFF.ArrayFormula = "=" & MinhaSelecao1 & "+" & MinhaSelecao2
>
> End Function-
>
> Does anyone can help me?
>
>
> --
> marcelobf
> ------------------------------------------------------------------------
> marcelobf's Profile:
http://www.excelforum.com/member.php...o&userid=32129
> View this thread: http://www.excelforum.com/showthread...hreadid=518850
>