|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub 调拨最大号()
Dim i, arr, p, n, flag As Boolean
With Sheets("数据库")
arr = .[a1].CurrentRegion
For i = 2 To UBound(arr, 1)
If Left(arr(i, 4), 1) = "T" Then
If Mid(arr(i, 4), 2, 6) = Format(Date, "yyyymm") Then flag = True
If n < Val(Mid(arr(i, 4), 2)) Then n = Val(Mid(arr(i, 4), 2)): p = i
End If
Next
If p > 0 Then
If flag Then
.Cells(.[D1].End(xlDown).Row + 1, "d") = "T" & (Val(Mid(arr(p, 4), 2)) + 1)
Else
.Cells(.[D1].End(xlDown).Row + 1, "d") = "T" & Format(Date, "yyyymm") & "001"
End If
End If
End With
End Sub |
评分
-
2
查看全部评分
-
|