巴打 個Case就咁
我VBA 整左個table啦 咁我再開多個column 就想用黎filter走D名
咁我就打喇窩 LastRow之前搵左係最低果行
For i=2 to LastRow
If Instr(Cells(i,1).Value, "ABC") > 0 Then
Cells(i,3).Value = "Type ABC"
End If
If Instr(Cells(i,1).Value, "DEF") > 0 Then
Cells(i,3).Value = "Type DEF"
End If
End For