Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
Using SumProduct in VB | Excel Discussion (Misc queries) | |||
Sumproduct? | Excel Worksheet Functions |