Sub 按钮1_Click()
Dim A, i%
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
Select Case A(i, 3)
Case 12 To 15
A(i, 4) = "短料"
Case 16 To 20
A(i, 4) = "常规料"
Case 21 To 30
A(i, 4) = "长料"
Case Else
A(i, 4) = "特殊物料"
End Select
Next i
Range("a1").Resize(UBound(A), UBound(A, 2)) = A
End Sub