[算表] VBA陣列運算問題(SUMIF)
軟體:EXCEL VBA
版本:2010
請教各位大大，下面程式中我想要計算不同的sumif值並存入ary(i)陣列中，
但出現"錯誤424，此處需要物件"的訊息，請問我是哪裡需要修正呢? 謝謝。
Sub test()
Dim a, b
Dim d
Dim ary(50)
a = Array("A", "B", "A", "B", "B", "C", "B", "C", "D", "B")
b = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
d = UBound(a)
For i = 0 To d
ary(i) =Application.WorksheetFunction.SumIf(a,a(i),b)
Next
End Sub
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.39.50.197
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1456744067.A.E86.html
→
02/29 19:33, , 1F
02/29 19:33, 1F
→
02/29 21:18, , 2F
02/29 21:18, 2F
→
02/29 21:22, , 3F
02/29 21:22, 3F
→
02/29 21:23, , 4F
02/29 21:23, 4F
→
02/29 23:14, , 5F
02/29 23:14, 5F
→
03/01 11:53, , 6F
03/01 11:53, 6F
→
03/01 11:53, , 7F
03/01 11:53, 7F
→
03/01 11:53, , 8F
03/01 11:53, 8F
→
03/01 11:54, , 9F
03/01 11:54, 9F
→
03/01 11:59, , 10F
03/01 11:59, 10F
→
03/01 12:00, , 11F
03/01 12:00, 11F
→
03/01 19:41, , 12F
03/01 19:41, 12F
討論串 (同標題文章)
完整討論串 (本文為第 1 之 2 篇)：
Office 近期熱門文章
PTT數位生活區 即時熱門文章