[µo°Ý]¨Ì¿z¿ï«á¸ê®Æ,¶ñ¤J¤é´Á°O¿ý(¤w¸Ñ¨M)
- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- Office XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-14
- ³Ì«áµn¿ý
- 2024-3-20
|
[µo°Ý]¨Ì¿z¿ï«á¸ê®Æ,¶ñ¤J¤é´Á°O¿ý(¤w¸Ñ¨M)
¥»©«³Ì«á¥Ñ ¤Ú§J´µ ©ó 2011-8-10 17:32 ½s¿è
¦pÃD&ªþ¥ó,½Ð°Ý¦p¦ó¥u°w¹ï¿z¿ï¹Lªº¸ê®Æ,¶ñ¤J¬ÛÃö¸ê®Æ,ÁÂÁÂ
¿z¿ï¸ê®Æ°O¿ý¤é´Á.rar (3.23 KB)
|
|
|
|
|
|
|
- ©«¤l
- 87
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- win 7
- ³nÅ骩¥»
- 2016
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-7-9
- ³Ì«áµn¿ý
- 2018-1-16
|
¸Õ¸Õ¬Ý¡A¤£ª¾¹D¬O¤£¬O§Anªº¡I- Sub ¥¨¶°2()
- '
- ' ¥¨¶°2 ¥¨¶°
- '
- '¿z¿ï¸ê®Æ
- ActiveSheet.Range("$A$1:$B$57").AutoFilter Field:=1, Criteria1:="B"
- '¥þ¿ï
- Range("A1").CurrentRegion.Select
- '¨ú¥N
- Selection.Replace What:="8/1", Replacement:="8/10", LookAt:=xlPart, _
- SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
- ReplaceFormat:=False
- End Sub
½Æ»s¥N½X |
|
ªì¾ÇVBA¥E¨ìtwbts
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- Office XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-14
- ³Ì«áµn¿ý
- 2024-3-20
|
¦^´_ 2# play9091
ÁÂÁ¦^ÂÐ
¤£¹L§Ú¬O¥ý¤H¤u¿z¿ï,·Qn°w¹ï¤w¿z¿ïªº¸ê®ÆB
¨ä¤é´Á¸ê®Æ8/1,·Q³v¤@¥[¤J·í¤é¤é´Á(¥Ñ8/1Åܦ¨8/1,8/10)---¥[¤J·í¤é8/10¸ê®Æ
¦]¬°¿z¿ï¥X¨ÓªºB¸ê®Æ¤¤,¨ä¸ê®Æ¤é´Á¤£¤@©w¥þ¬O8/1(©êºp¨SÁ|¨Ò¦n)
©Ò¥H¤£¥þµM¥Î³æ¤@ªº¨ú¥N,½Ð°Ý¦p¦óÀò¨ú³vÄæ¦ì¸m,¥[¤J·í¤é¤é´Á¸ê®Æ
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
- Sub yy()
- With ActiveSheet
- If .FilterMode Then
- For Each c In .[b:b].SpecialCells(2, 23)
- If c.Row > 1 Then c.Value = c.Value & "," & Application.Text(Date, "m/d")
- Next
- End If
- End With
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 122
- ÂI¦W
- 0
- §@·~¨t²Î
- WINXP
- ³nÅ骩¥»
- Office XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-14
- ³Ì«áµn¿ý
- 2024-3-20
|
RE: [µo°Ý]¨Ì¿z¿ï«á¸ê®Æ,¶ñ¤J¤é´Á°O¿ý(¤w¸Ñ¨M)
¦^´_ 4# oobird
ÁÂÁ¤ì¤uª©¤j,°ÝÃD¸Ñ¨M¤F
µ{¦¡¤Sºë²,§Ún¦n¦n¾Ç²ß |
|
|
|
|
|
|