Sub aa() Dim arr Dim i As Long arr = Range("c1:d" & Range("d65536").End(xlUp).Row).Value For i = 1 To UBound(arr, 1) If arr(i, 2) Like "*1月*" Then arr(i, 1) = 11 ElseIf arr(i, 2) Like "*6月*" Then arr(i, 1) = 23 Else arr(i, 1) = "" End If Next i Range("c1").Resize(UBound(arr, 1), 2) = arr End Sub 在第一个的基础上改红色部份就行了,其他不用改 |