|
输入格式变了(变成month/month/.../...),n不再是数值型,所以错误提示需要你自己修改一下。
代码如下:
- Private Sub CommandButton1_Click()
- Dim n, arr, i&, mon&, ye&
- n = Split(InputBox("Pls inout month"), "/")
- ReDim arr(0 To (UBound(n) + 1) * 2 - 1)
- For i = 0 To UBound(n)
- mon = Val(n(i)) + 1
- If mon > 12 Then
- mon = 1
- ye = 2020
- Else
- ye = 2019
- End If
- arr(i * 2) = 1
- arr(i * 2 + 1) = DateSerial(ye, mon, 0)
- Next i
- With Sheets("AA")
- .Range("H2").Select
- .Range("A2:B2" & [a65536].End(3).Row).AutoFilter Field:=1, Operator:=xlFilterValues, Criteria2:=arr
- Range("H2") = Application.Subtotal(103, Range("A3:A65536"))
- End With
- End Sub
复制代码
|
评分
-
查看全部评分
|