ªð¦^¦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 : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD