ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦Û°Êsorting°ÝÃD´M°Ý

[µo°Ý] ¦Û°Êsorting°ÝÃD´M°Ý

DEAR  ALL ¤j¤j
1.¦p¤U¬°¿ý»s¤§¥¨¶°
   Selection.AutoFilter Field:=2, Criteria1:="=CCLX51", Operator:=xlAnd
2.·Q±N  CCLX51 §ï§ì¨ú  Range("P1")  ¤§¤º®e SORTING.­×§ï¦p¤U.¦ý§ì¨ú¥XªÅ¥Õ??
   Selection.AutoFilter Field:=2, Criteria1:="= " & Range("P1") & "", Operator:=xlAnd
3.¦pªþÀÉ  . ·Ð¤£§[½ç±Ð.  THANKS  *10000

1.rar (13.38 KB)

¦^´_ 1# KITTYBOY


    Criteria1:=Range("P1")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    DEAR  ¤j¤j -
     ­ì¨Ó¦p¦¹  TEST  OK   ¨ü±Ð°Õ
      ¸U¤À·PÁ   THANKS    ROBERT 07/29

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD