Thread: Using FormulaArray in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marcelobf marcelobf is offline
external usenet poster
  
Posts: 1
Default 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?


--
marcelobf
------------------------------------------------------------------------
marcelobf's Profile: http://www.excelforum.com/member.php...o&userid=32129
View this thread: http://www.excelforum.com/showthread...hreadid=518850

Reply With QuoteReply With Quote