- ©«¤l
- 1
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 7
- ÂI¦W
- 0
- §@·~¨t²Î
- 7
- ³nÅ骩¥»
- excel
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-6-12
- ³Ì«áµn¿ý
- 2013-6-12
|
[µo°Ý] ¦p¦ó¥ÎÀx¦s®æªºÈ¨Ó¨Ï¥Îfilter?
- Dim stocknumber As Range
- Set stocknumber = Range("A2")
- ActiveSheet.Range("$A$1:$G$4").AutoFilter Field:=3, Criteria1:=stocknumber.value
½Æ»s¥N½X Criteria1:=stocknumber.value¦n¹³¦³°ÝÃD, ¦p¦óקï, thz a lot |
|