本帖最後由 papaya 於 2017-11-19 19:34 編輯
- Private Sub CommandButton1_Click()
- '[A2] = "=Max(D:D)"
- '[A2] = [A2].Value
- [A2] = Application.Max(Range("D:D"))
- [B1] = [I2]
- [B2] = [D2]
- [C2] = "=INDEX(D:D,MATCH(A2,I:I,))"
- [C2] = [C2].Value
- [C1] = "=SUMIF(OFFSET($I$1,C2-B2+1,1,,4),A1,OFFSET($D$1,C2-B2+1,1,,4))"
- [C1] = [C1].Value
- End Sub
複製代碼 A1=人工填入
EX︰
'[A2] = "=Max(D:D)"
'[A2] = [A2].Value
可轉化為
[A2] = Application.Max(Range("D:D"))
請問︰
[C2]和[C1]要如何轉化?
PS:Sheet2和Sheet3只作輔助說明用;完成後就移除。
先感謝各位大大的熱心協助。
12生肖-VBA-Q.rar (10.03 KB)
|