How to use Sumproduct in VBA???
Hi friends,
I wanna know what's the problem with:
Public Function FHWA(One, Two)
FHWA=Application.Caller.Parent.Evaluate( _
"SUMPRODUCT("&One.Address&","&Two.Address&")")
End Function
The code gives a:
Compile Error
Expected: list separator or )
What would be the appropriate way to write a simple code for sumproduct of
two arrays named One & Two?
Thanx
|