Public Function MyMult(a, b)
If Application.Caller.HasArray Then
Dim valsA(), valsB(), r&
valsA = a.Value
valsB = b.Value
For r = LBound(valsA) To UBound(valsA)
valsB(r, 1) = valsA(r, 1) * valsB(r, 1)
Next
MyMult = valsB
Else
MyMult = a * b
End If
End Function
1 回答
将参数声明为变体 . 然后使用
Application.Caller.HasArray
检查UDF是否用作数组公式:请注意,在按CTRL SHIFT ENTER之前需要选择C1:C3 .