VBA 中 scalar * martirx 報错???
Function abc(x As Range)
Dim m As Integer, n As Integer
m = x.Rows.Count
n = x.Columns.Count
Dim matrix()
Redim matrix(1 To m, 1 To n)
For i = 1 To m
For j = 1 To n
matrix(i, j) = x(i, j)
Next j
Next i
Dim sum As Single
sum = Application.WorksheetFunction.sum(matrix)
Dim norm()
ReDim norm(1 To m, 1 To n)
For i = 1 To m
For j = 1 To n
norm(i, j) = matrix(i, j) / sum <--REPORTING ERROR HERE!!!
Next i
Next j
abc = norm
End Function