不知道是不是这个意思?{:4412:}
- Sub 按钮1_Click()
- Dim ar
- Dim i As Long
- Dim bh As String
- Dim temp As Long
- bh = Cells(2, "K").Value
- ar = Range("N2:N" & Cells(Rows.Count, "N").End(3).Row)
- For i = 1 To UBound(ar)
- If Left(ar(i, 1), 5) = bh Then
- If Val(Right(ar(i, 1), 4)) > temp Then
- temp = Val(Right(ar(i, 1), 4))
- End If
- End If
- Next i
- Cells(2, "M") = bh & Format(temp + 1, "0000")
- End Sub
复制代码
|