²¾°Ê¦³ÃC¦âªº¦C¨ì¨ä¥Lsheet(¤p°ÝÃD½Ð±Ð)
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
²¾°Ê¦³ÃC¦âªº¦C¨ì¨ä¥Lsheet(¤p°ÝÃD½Ð±Ð)
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¦^´_ 3# GBKEE
Dear GBKEE ª©¥D¡G
ÁÂÁ±zªº¦^À³¡A¦ý¬O¥X²{¤@ÂI°ÝÃD
¦pªG±z¦³ªÅ¡A¥i¥H¦A³Â·Ð±z¬Ý¤@¤U
·PÁÂ
|
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¥»©«³Ì«á¥Ñ jj369963 ©ó 2013-11-1 22:03 ½s¿è
¦^´_ 3# GBKEE
sorryÁÂÁ´£¿ô¡A¦pªþÀÉ
¤]ÁÂÁª©¤jªº¿n·¥¦^À³
test_m.rar (62.78 KB)
|
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¦^´_ 2# kimbal
Dear kimbal ª©¤j :
Thanks your reply, but it didn't work.
1.¸ê®Æµ§¤Ö®É¡A¦³·h²¾¦ý¬O¥¼·h²¾§¹¥þ
2.¸ê®Æµ§¦h®É§¹¥þ¨S¤ÏÀ³
¦pªþÀÉ¡A½Ð°Ñ¾\
reply_1.rar (65.11 KB)
|
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¦^´_ 7# GBKEE
Dear GBKEEª©¤j¡G
±z¦n
ªþÀɦ³2ÓÀÉ®×(¤u§@ªí¦WºÙ³£¬Û¦P)¦³¦P®É¶}±Ò,°õ¦æEXµ{¦¡¶Ü?
¦^ÂСG§Ú¨S¦³¦P®É¶}±Ò
¥t¥~°õ¦æ»yªk«á¥u¦³¼ÐÃD¦C²¾¹L¥h¡A®æ¦¡¤Æªº¦C¨S¦³²¾¨ì¹ïÀ³ªºsheet
³o¦¸¨S¦³¶]¥X¿ù»~µøµ¡
¤£ª¾°ÝÃD¦bþ??
¦A·Ð½Ð¦³ªÅ¤§¾l¡A«ü±Ð»P¨ó§U
·PÁÂ
test_m_1.rar (62.79 KB)
|
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¥»©«³Ì«á¥Ñ jj369963 ©ó 2013-11-3 18:10 ½s¿è
¦^´_ 9# GBKEE
Dear GBKEEª©¤j:
±z¦n
1.´ú¸Õ«á¡A¥u·h²¾¼ÐÃD¦C¡A®æ¦¡¤Æªº¦C¨Ã¥¼·h²¾
ÁÂÁ¡A¦A·Ð½Ð«ü±Ð
¥t¥~³o¬O§Ú¥Î¿ý»s°µªº»yªk¨Ó®M¥Î¡A¤]¥X¿ù¡A¦ý®É¦³®É¦³§â³¡¤À¦C²¾¹L¥h¡A
¦A³Ò·Ð±z¬Ý¤@¤U¤F¡A·PÁÂ- Sub Macro1()
- '
- Cells.Select
- Selection.AutoFilter
- ActiveSheet.Range("$A$1:$CQ$376").AutoFilter Field:=6, Criteria1:=RGB(250, _
- 192, 144), Operator:=xlFilterCellColor
- Selection.Copy
- Sheets("µL§@µª").Select
- ActiveSheet.Paste
- Sheets("Sheet0").Select
- Application.CutCopyMode = False
- Rows("59:411").Select
- Selection.Delete Shift:=xlUp
- ActiveSheet.Range("$A$1:$CQ$370").AutoFilter Field:=6, Criteria1:=RGB(3, _
- 255, 101), Operator:=xlFilterCellColor
- Selection.Copy
- Application.CutCopyMode = False
- Selection.Copy
- Rows("1:338").Select
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("µL±b±K").Select
- ActiveSheet.Paste
- Sheets("µL±b±K").Select
- Rows("18:402").Select
- Application.CutCopyMode = False
- Rows("18:18").Select
- ActiveWindow.SmallScroll Down:=-3
- Rows("18:402").Select
- Selection.Delete Shift:=xlUp
- Selection.AutoFilter
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¦^´_ 12# GBKEE
Dear GBKEE ª©¤j¡G
«D±`ÁÂÁ±zªº¦^ÂСA¦Ó¥B¦^ÂЪº¦n¸Ô²Ó¡A·PÁ¡C
¡y§A»¡ªº°õ¦æ»yªk«á¥u¦³¼ÐÃD¦C²¾¹L¥h¡A®æ¦¡¤Æªº¦C¨S¦³²¾¨ì¹ïÀ³ªºsheet,(¦Ê«ä¤£¸Ñ..)¡z
¦^ÂСG¦pªþÀÉ
¤£¹L§Ú¦b·Q·|¤£·|¬Oexcelª©¥»ªº®t²§(???)¡A¦]¬°ª©¤j¦³°õ¦æ¥X¨Ó¡A©Ò¥H°ÝÃDÀ³¸Ó¦b§Ú³oÃä¡C
ÁÂÁª©¤j¥Î¤ß¥B¸Ô²Óªº¦^ÂÐ
|
|
|
|
|
|
|
- ©«¤l
- 147
- ¥DÃD
- 46
- ºëµØ
- 0
- ¿n¤À
- 205
- ÂI¦W
- 0
- §@·~¨t²Î
- windows xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2012-3-19
- ³Ì«áµn¿ý
- 2021-5-21
|
¦^´_ 14# Hsieh
Dear Hsieh ¶Wª©:
«D±`·PÁ±zªº¸É¥R»¡©ú¡AÁÙ¬O¤@¦p¬J©¹ªº¼ö¤ß¡Ait works.
¯u¬O¤Ó·PÁ¤F¡A¤]ÁÂÁÂGBKEE¼ö¤ßªº«ü¾É
·PÁÂ2¦ì |
|
|
|
|
|
|