Dim a, b As Integer, C As String
b = Sheet10.[a65536].End(xlUp).Row - 1
For a = 1 To b Step 1
C = Cells(a + 1, "Au")
Select Case CInt(C)
Case Is = 58, 42, 172, 62 ' (满足同等条件 CASE 语句只能分开很多 case 语句吗,想并列写在一起怎么办)
'执行同样的程序1
Case Is = 49, 331, 338, 413 To 415 ' (满足同等条件 CASE 语句只能分开很多 case 语句吗,想并列写在一起怎么办)
'执行同样的程序2
Case Else
'执行同样的程序3
End Select
Next a