¦³¨S¦³¤H¦³ªÅ¥i¥HÀ°§Ú¬Ý¤@¤U§Úªº¿ý»s¥¨¶°¦³¨S¦³¤ñ¸û²¤Æªº¼gªk?
- ©«¤l
- 155
- ¥DÃD
- 56
- ºëµØ
- 0
- ¿n¤À
- 242
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- ±M·~ª©2002
- ¾\ŪÅv
- 0
- µù¥U®É¶¡
- 2010-5-29
- ³Ì«áµn¿ý
- 2011-7-18
|
¦³¨S¦³¤H¦³ªÅ¥i¥HÀ°§Ú¬Ý¤@¤U§Úªº¿ý»s¥¨¶°¦³¨S¦³¤ñ¸û²¤Æªº¼gªk?
¦³¨S¦³¤H¦³ªÅ¥i¥HÀ°§Ú¬Ý¤@¤U§Úªº¿ý»s¥¨¶°¦³¨S¦³¤ñ¸û²¤Æªº¼gªk?
http://naturefruit.myweb.hinet.net/222.xls
¨ä¹ê§Úªºªí®æn¤@ª½ÂX±i¨ì§Ç¸¹500,¥i¬O¦]¬°¿ý¨îªº¥¨¶°¤Óªø,¬O§_¦³Â²µuªº°µªk©O?
ÁÙ¦³¤@Ó¤ñ¸û§xÃøªº§PÂ_¦¡
·íB25¨S¦³¸ê®Æ,±N¤£Åã¥Ü©ÎÁôÂÃA25:G65536ªºÀx¦sÓ
·íB46¨S¦³¸ê®Æ,±N¤£Åã¥Ü©ÎÁôÂÃA46:G65536ªºÀx¦sÓ
.
.
.
¥H¦¹Ãþ±À
·PÁ¦U¦ì±M®a¤j¤jªºÀ°¦£,«D±`ÁÂÁÂ.
|
|
|
|
|
|
- ©«¤l
- 155
- ¥DÃD
- 56
- ºëµØ
- 0
- ¿n¤À
- 242
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- ±M·~ª©2002
- ¾\ŪÅv
- 0
- µù¥U®É¶¡
- 2010-5-29
- ³Ì«áµn¿ý
- 2011-7-18
|
§Úè¶]¦n¹³¤Ö21¦C
©Ò¥H§Ú¤S§ó§ï¤F¤@¤U
Sub nn()
i = 25
Do Until Cells(i, 2) = ""
i = i + 21
Loop
i = i + 21
Sheets("¥Ø¿ý®æ¦¡").Rows(i & ":65536").Select
Selection.Delete Shift:=xlUp
End Sub
§Ú¼W¥[¤F¬õ¦âªº³¡¤À´N¥¿±`¤F,¤£ª¾¹D¬O¬°¤°»ò©O?
|
|
|
|
|
|
- ©«¤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
|
§Úµo²{ÁôÂÃ,¹wÄý¦C¦LÁÙ¬O·|¦L¥XÁôÂ꺦C.
³oˬO¬Û·íµ}©_¡C |
|
|
|
|
|
|
- ©«¤l
- 155
- ¥DÃD
- 56
- ºëµØ
- 0
- ¿n¤À
- 242
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- ±M·~ª©2002
- ¾\ŪÅv
- 0
- µù¥U®É¶¡
- 2010-5-29
- ³Ì«áµn¿ý
- 2011-7-18
|
¥»©«³Ì«á¥Ñ vpower ©ó 2010-11-16 00:37 ½s¿è
§Úµo²{ÁôÂÃ,¹wÄý¦C¦LÁÙ¬O·|¦L¥XÁôÂ꺦C.
§ï¥Î§R°£§Ú¨Ì¼Ëµe¸¬Äª¦p¤U,½Ð¤j®vÀ°§ÚÀˬd¤@¤U,·P®¦
Sub nn()
i = 25
Do Until Cells(i, 2) = ""
i = i + 21
Loop
Sheets("¥Ø¿ý®æ¦¡").Rows(i & ":65536").Select
Selection.Delete Shift:=xlUp
End Sub
|
|
|
|
|
|