¦b¤£¦P¤u§@ªí¤¤§ä´M©³¦â¬Û¦Pªº¸ê®Æ¨Ã§R°£
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦b¤£¦P¤u§@ªí¤¤§ä´M©³¦â¬Û¦Pªº¸ê®Æ¨Ã§R°£
|
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-8-4
- ³Ì«áµn¿ý
- 2018-10-22
|
¦^´_ 1# Changbanana
¸Õ¸Õ¬Ý- Dim myRow As Integer
- Sheets("sheet1").Activate
- Range("B2").Select
- Do While ActiveCell <> ""
- myRow = WorksheetFunction.Match(ActiveCell, Sheets("sheet2").Range("A:A"), 0)
- If Sheets("sheet2").Cells(myRow, "A").Interior.ColorIndex = 14 Then
- Rows(ActiveCell.Row).Delete
- Else
- ActiveCell.Offset(1, 0).Select
- End If
- Loop
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 2# zyzzyva
z¤j~
§âµ{¦¡½X¥´¶i¥h«á¤u§@ªí³£¨S¤ÏÀ³C
¤£ª¾¹D¬O¨º¨à¥X¤F°ÝÃD
ªþ¤WÀÉ®×
·s¸ê®Æ§¨.zip (387.18 KB)
|
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 2# zyzzyva
Åã¥Ü¥Xªº¿ù»~¦p¹Ï
|
|
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-8-4
- ³Ì«áµn¿ý
- 2018-10-22
|
¦^´_ 3# Changbanana
ÃC¦âªº°ÝÃD¡AColorIndex¨ºÃän§ï¦¨43¡C
¥i¥H²³æ¥ÎmsgboxÀˬdÃC¦â¹ïÀ³ªº¼Æ¦r¡C- mycolor = Sheets(2).Range("A2").Interior.ColorIndex
- MsgBox (mycolor)
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 5# zyzzyva
ì¨Ó¦p¦¹~¤w¸g¨S°ÝÃD¤F
ì¨Ó¥i¥H³o¼Ë¬dÃC¦â~
·PÁ§Aªº¸Ñµª :) |
|
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-8-4
- ³Ì«áµn¿ý
- 2018-10-22
|
¦^´_ 6# Changbanana
¤£«È®ð¡C¦pªGsheet1ªºid³£·|¦bsheet2¥X²{¡A¥u¬O¶¶§Ç¤£¤@¼Ë¡A¨º³o¼Ë´N¥i¥H¤F¡F
¦pªG¤£¤@©wªº¸Ü´Nn¥[¤W¿ù»~³B²z¡A¤£µMmatch§ä¤£¨ìªº®ÉÔ´N·|¥X²{¿ù»~°T®§¡C |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 7# zyzzyva
¹ïC
¦]¬°èè¦b¥[¸ê®Æ«á¨Ó¤S¤£¦æ
¥¿¦p¦P±z©Ò»¡"sheet1ªºid³£·|¦bsheet2¥X²{"¡A³o¬O¤£¤@©wªº
sheet1ªºID¬O·í¤ë¥þ³¡¸ê®Æ
sheet2ªºID¬O·í¤ë³¡¥÷¸ê®Æ¥~¥[´Xµ§«e´XӤ몺ID¸ê®Æ
¨ºn¸Ó«ç»ò¥[¤W¿ù»~³B²z©O?
²{¦b¤@ª½¥X²{¿ù»~°T®§0.0 |
|
|
|
|
|
|
- ©«¤l
- 109
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 116
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2016-8-4
- ³Ì«áµn¿ý
- 2018-10-22
|
¦^´_ 8# Changbanana
¸Õ¸Õ¬Ý¡C- Dim myRow As Integer
- Sheets("¤u§@ªí1").Activate
- Range("B2").Select
- Do While ActiveCell <> ""
- If IsError(Application.Match(ActiveCell, Sheets("¤u§@ªí2").Range("A:A"), 0)) Then
- ActiveCell.Offset(1, 0).Select
- Else
- myRow = WorksheetFunction.Match(ActiveCell, Sheets("¤u§@ªí2").Range("A:A"), 0)
-
- If Sheets("¤u§@ªí2").Cells(myRow, "A").Interior.ColorIndex = 43 Then
- Rows(ActiveCell.Row).Delete
- Else
- ActiveCell.Offset(1, 0).Select
- End If
-
- End If
-
- Loop
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¦^´_ 9# zyzzyva
ÁÂÁ§A~
¨S·Q¨ì¥i¥H§Q¥Îmatch¨Ó°µ
¤S¾Ç¨ì¤F¤@½Ò~~~ |
|
|
|
|
|
|