- ©«¤l
- 17
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- Win XP
- ³nÅ骩¥»
- SP3
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-9
- ³Ì«áµn¿ý
- 2022-11-28
|
[µo°Ý] keywordªº±ø¥óY¹F2ºØ¥H¤W¡A¸Ó¦p¦ó«Ø¥ß»yªk?
½Ð°Ý¤U¦C»yªk¡Akeywordªº±ø¥óY¹F2ºØ¥H¤W¡A¸Ó¦p¦ó«Ø¥ß»yªk?³Â·Ð½ç±Ð¡A·PÁ¡C
Sub BBB()
keyword = "AW1"
For i = 7 To 26
If Cells(i, 1) Like "*" & keyword & "*" Then
Cells(i, 3) = ""
Cells(i, 4) = ""
Cells(i, 5) = ""
Cells(i, 6) = ""
End Sub |
|