ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

±þ¤u§@ªí¦C¡I¡I¡I

±þ¤u§@ªí¦C¡I¡I¡I

¤£ª¾¤°»ò®É­Ô§ÚªºexcellÅܤj¤F
¤Ñ§r¡I
¦³1048576¦C
±þ¨ì²{¦bªº7488085¦C
±þªº®É­Ô·|¥X²{ªºÄµ§i»y
¦pªþ¹ÏÀÉ
§Ú¥u·Q¦bA1:K802¤º¤u§@­n¦p¦ó³]©w©Î¦p¦ó±þ±¼¤£¥ÎªºÀx¦s®æ¡C
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# ¦Û§Ú·Pı¨}¦n


    ÀÉ®×¥¼¤W¶Ç¦¨¥\ ½Ð¬d¬Ý

¤j¤j©Ò©w¸qªº ¤£­nªºÀx¦s®æ ¬O«ü?

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_ 2# mark15jill
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# ¦Û§Ú·Pı¨}¦n
¦p¦ó¤@¦¸±þA803:A1048576¡H

002.JPG (57.61 KB)

002.JPG

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

±z¬O­n§R°£ ¾ã¦C ÁÙ¬O³æ¯Â A803:A1048576   ¡H

¾ã¦Cªº¸Ü  
Rows("803:1048576").Select
Selection.Delete Shift:=xlUp

³æ¯Âªº¸Ü  
range("803:1048576").Select
Selection.Delete Shift:=xlUp

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¤u§@ªíªºÄæ¦C³£¬O©T©wªº¡A­þ±þ±o±¼¡H
­Y§A¤£¨Ï¥Î³o»ò¦h¥i³]¸m¨Ï¥Î½d³ò

TOP

¦^´_ 3# ¦Û§Ú·Pı¨}¦n

«Øij±z²¾°£2007ª©¥»¡A¨Ï¥Î2003ª©¥»§Y¥i
¥i¯à±zªº¨t²Î¸ê·½¤£°÷2007ª©¥»¨Ï¥Î
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# chin15

¶â¶â¡KÁÙ¬O¹w³]¸m¨Ï¥Î½d³ò¤ñ¸û¹ê¦b
Á`ºâ¨M¸Ñ¤FÀÉ®×Åܤj¤u§@ÅܺCªº°ÝÃD
3q
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¨ä¹ê ÁÙ¦³ºØ¤èªk
  1.     Rows("3:3").Select
  2.     Selection.EntireRow.Hidden = True
  3.     Columns("F:F").Select
  4.     Selection.EntireColumn.Hidden = True
½Æ»s¥N½X
¦^´_ 8# ¦Û§Ú·Pı¨}¦n

¥u¬O³o¼Ë¦³ÂI ²´¤£¨£¬°¾Ì ªº·N«äXD
(§â¦hªº ¤£·Q­nªº µ¹¥LÁôÂÃ)

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¥»©«³Ì«á¥Ñ dakiu ©ó 2012-9-21 17:27 ½s¿è

¿ïA803->ctrl+g->¿é¤JA1048576 §O«ö½T©w   «öSHIFT«á¦A«ö½T©w
1)¥u§R¤º®e«öDEL
2)­n§R¦C ¶·«öSHIFT ÂI1048576Äæ¦ì·|Åܦ¨¦C¥þ³¡¿ï¨ì....¦b«öDEL

¥i°Ñ¦Ò°Ñ¦Ò.....

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD