½Ð°Ý°ª¤ân±N¥H¤UDDE ¨C¤ÀÄÁ°O¿ý§ï¬°30¬í¦Û°Ê°O¿ý¤@¦¸n«ç§ï
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 75# GBKEE
§Ú¦A¦¸«·s DEBUG ¤@¦¸¡Aµ²ªG¬O¡G
ÁöµM¦b¹ê°È¤W§Úª¾¹Dn¦p¦ó³Bù¡A¦ý¤H¬¡µÛ´N¬On¦h¦h¾Ç²ß¡A
¤£¼ô±xªº»yªkn²`¤Á¥hÁA¸Ñ¡A¤£¬O¹À¡H |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 73# GBKEE
¦]¬°§Ú«D¥¿¬ì¯Z¥X¨¡A³o¦æ»yªk¤ºªº Offset(2) «üªº¬O¡H
¬O±q²Ä¤@¦C°_ºâ¤§¤U¨â¦æ (§Y²Ä¤T¦C) °_§R°£¡AÁÙ¬O¡H
¦pªG¥L¦³¤T¦C¥H¤W§k¦X±ø¥óªº¸ê®Æ¶µ¤S¬O¦p¦ó³B²z¡H |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 70# c_c_lai
ªþ¤W°õ¦æ«á¤§¹Ï¥Üµe±¡G
|
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 69# GBKEE
§Ú«üªº¬O¡G- Option Explicit
- Sub Ex()
- Dim Car_No As String, xlRow As Integer
-
- With Sheet1
- .Activate
- .AutoFilterMode = False
-
- Car_No = InputBox("½Ð¿é¤J¨®¸¹")
- If Car_No = "" Then MsgBox "¨S¿é¤J ¨®¸¹ ??" & Car_No: Exit Sub
-
- .Rows(2).Cells(1).AutoFilter Field:=9, Criteria1:=UCase(Car_No) ' 9 - ¨®¸¹
- ' AutoFilter °õ¦æ§¹²¦«á¡A¦¹®É¤u§@ªí³æ¤º®e¶È·|Åã¥Ü»PCar_No±ø¥ó§k¦X¤§¸ê®Æ¶µ¡C
- ' °²³]즳5µ§¬ö¿ý¡A¦Ó§k¦X±ø¥óªº¥u¦³2µ§¡A¨º¦¹®Éªí³æ¤º®e¥uÅã¥Ü¥X¨º2µ§¸ê®Æ¿ý¡C
- xlRow = .Rows(2).Cells(9).End(xlDown).Row
-
- If xlRow <> Rows.Count Then ' Rows.Count = 65536
- .Cells.SpecialCells(xlCellTypeVisible).Copy ' ±Nªí³æ¤º©Ò¦³¤º®e½Æ»s¡C
- Else
- MsgBox "§ä¤£¨ì ¨®¸¹ !! " & Car_No: Exit Sub
- End If
-
- With Sheets.Add(, Sheets("sheet1")) ' ¦bìsheet1«á·s¼W¤@Ó¤u§@ªí³æ(¤u§@ªí1)
- .Paste ' ±N½Æ»s¤§©Ò¦³¤º®e¶K¤J¦Ü·sªí³æ¤º¡C
- Application.CutCopyMode = False
- .Name = .[i3] ' ±N·s¼W¤§¤u§@ªí³æ¡A©R¦W¬°Car_Noªº¤º®e¡C
- .[a1].Select ' ±N´å¼Ð²¾¦Ü A1 Äæ¦ì¤W¡C
- End With
-
- .Rows(xlRow).Delete ' ±Nìsheet1¤º²ÄxlRow¦C¸ê®Æ¶µ§R°£±¼¡C([color=Red]Why?[/color])
- .AutoFilterMode = False
- .Activate
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 68# minyow
¶¡®æ®É¬q¥i¨Ì§AÓ¤H»Ý¨D¤©¥H§ó°Êªº¡A
Ä´¦p¡G ¤@¬í¡B¤¬í¡B¤Q¬í¡B¤G¤Q¬í¡B¤T¤Q¬íµ¥¡A
¥ç©Î¬O¤@¤À¡B¤¤À¡B¤Q¤À¡B¤G¤Q¤À¡B¤T¤Q¤À¡C
§A¥un²§°Ê¶¡®æ®É¬q¸ÓÄæ¦ìȧY¥i¡A«D±`¤è«K¡C
½L¤¤×¥¿¥¦·|¦b²§°Ê«á¤§¤U¤@½ü°j¦Û°Ê×¥¿ªº¡C |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 58
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWXP
- ³nÅ骩¥»
- OFFICE2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- ¨Ó¦Û
- TAIWAN
- µù¥U®É¶¡
- 2012-10-15
- ³Ì«áµn¿ý
- 2012-11-25
|
|
§Ú
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 66# GBKEE
§Úª¾¹D¡A³o¬O¬G·N©ñ¤Wªº¡A¦]¤@¶}©l·|Åã¥Ü UserForm1 ¤£¦n¬Ý¤~©ñ¤Wªº¡A
ÁÂÁ±z¡I
¶¶«K½Ð±Ð¡A¦b¦p¦ó¦Û°Ê¿z¿ï+¦s¨ì·s¤u§@ªí¸Ì¡A³Ì«á¬°¤°»òn .Rows(xlRow).Delete
§R°£ xlRow ¨ºµ§¬ö¿ý©O¡H ¦]¬°¥¦¦³ 2 µ§©O¡C |
|
|
|
|
|
|