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

[­ì³Ð] ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤@¼u

[­ì³Ð] ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤@¼u

ªü¦NExcel ¥¼¤½¶}ªºÁôÂÃÄæ¦C§Þ¥© ±j¤O²Ä¤@¼u

¦¹³¡¥÷­º­«¦bÁ¿¸ÑExcelÄæ¦CÁôÂçޥ©
À³¥Î©óSHEET¤W

*************************************************************************
µ{¦¡«e¥x³¡¥÷ ¦p¤Uªí½d¨Ò
¸Ñ°£¦¹ªí­º¥ý
1.¥´¶}  ¤u§@ªí±K½X »P ¬¡·~ï±K½X ±K½X¬° "¨S±K½X"
2.¥´¶}­áµ²µ¡®æ
3.¨ì¿ï¶µ §â¤u§@ªí¼ÐÅÒ»PÄæ¦C¼ÐÃD¥´¶} ¥HÅã¥ÜÄæ¦C¼ÐÃD»P¤u§@ªí¼ÐÅÒ

4.¸Ñ°£ÄæÁôÂà ¨Ï¥Î³q¥ÎÄæÁôÂÃ+Äæ¦ìÁY¤p¬°¶H¯À1
5.¸Ñ°£¦CÁôÂà ·|²£¥ÍµLªk¸Ñ°£¦CÁôÂîĪG ¨Ï¥Î¯S®í¦CÁôÂÃ(¦¹¤èªk©|¥¼¦bEXCEL¥@¬Éµoªí¹B¥Î»P¬y³q¹L ¥i¥H¦h¬Ý¬Ý)

*************************************************************************


³o¤@«h«Ü¦­«e¦bofficefans½×¾Â"¶i¶¥¿z¿ïÁ¿¸q"¤¤»¡¹L¤@¦¸ ¬O§Q¥Î¶i¶¥¿z¿ïªº¤@ºØ«O
Å@¤èªk ²{¦b§â¥¦§e²{¥X¨Ó
http://www.officefans.net/cdb/viewthread.php?
tid=66374&extra=&page=2
发ªí¤_ 2007-3-4 10:10 ¥u¬Ý该§@ªÌ

隐ÂÃSHEET
^^
这¨½¤£谈这个 论坛¤¤«Ü¦h¥i¥H¦h·j寻 ¦³¥|Ïú¤èªk¥H¤W

¤£过进阶筛选 ¦³«O护®ÄªG吗? µª®×¬O¦³ªº 筛选¦Z 没¨ú®ø进阶筛选
¬O无ªk¨ú®ø隐ÂæCªº
¤£ª¾¹Dªº¤H´N无ªk¬Ý¨ì隐ÂæC¤F

³o«h½d¨Ò©Ò­n§e²{ªº®ÄªG:1¤£¯à¥Î¥¿±`¤èªk¨ú®ø¦CÁôÂÃ
¤W­zªº®ÄªG¬O­«ÂI¤¤ªº­«ÂI
·|Åý°ª¤â¸s³£­n·Q¤@¤U³o¨ì©³¬O¤°»òªF¦è

§@ªk:1¦bsheet¤¤»s§@¤@­Ó¶i¶¥¿z¿ï 2¨Ï¥Î¶i¶¥¿z¿ïÅý¦³¸ê®Æªº¦a¤èÅã¥Ü¥X
¨Ó´N¦n3²M°£¾ãÄæ¶i¶¥¿z¿ïªºdata Åý¶i¶¥¿z¿ïµLdata 4¦sÀÉ

¤ß±o¬O:²³æªº¥\¯à¦ý«Ü¦h¤H¤£·| ¤]¤£ª¾¹D¶i¶¥¿z¿ï®É·|¦³³o®ÄªG ·í¥¦­n¨Ï
¥Î¤@¯ë¤u¨ã¦C¤W Äæ¦C¨ú®øÁôÂîɷ|µo²{µLªk¨ú®ø¦C
¬O«Ü¦nª±ªº§Þ¥© §Æ±æ¹ï¤j®a¦³À°§U
A5.rar (5.11 KB)

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-6-6 19:20 ½s¿è

¦^´_ 1# HUNGCHILIN
    ¯u¬O¤£¿ùªº§Þ¥© Æ[¬Ý«á ¸Ñ°£¦Cªº¤è¦¡¦p¤U
  ¿ï¨ú¾ã­Ó¤u§@ªí ©Î ¥ô1¾ãÄæ«á,°õ¦æ¦Û°Ê¿z¿ï¤G¦¸§Y¥i.  (²Ä¤@¦¸¬O°õ¦æ¿z¿ï ²Ä¤G¦¸¬O¨ú®ø¿z¿ï)
VBA ªºµ{§Ç¦p¤U
  1. Sub Ex()
  2.     With ActiveWorkbook.ActiveSheet.Cells
  3.         .AutoFilter
  4.         .AutoFilter
  5.     End With
  6. End Sub
½Æ»s¥N½X

TOP

¥Î¤@¯ë¤u¨ã¦C¤W Äæ¦C¨ú®øÁôÂîɷ|µo²{µLªk¨ú®ø¦C
HUNGCHILIN µoªí©ó 2010-5-2 20:18

¬O¦]Äæ¦Cªº°ª«×¼e«×³]©wÃö«Y
  1. Sub Ex()
  2.     With ActiveWorkbook.ActiveSheet.Cells
  3.         .ColumnWidth = 2
  4.         .RowHeight = 2
  5.         .EntireColumn.AutoFit
  6.         .EntireRow.AutoFit
  7.     End With
  8. End Sub
½Æ»s¥N½X

TOP

¦^´_ 1# HUNGCHILIN

¯u¬O¤£¿ùªº§Þ¥©
¦hÁ¡ã

TOP

ÁÙ¤£¿ùªº§Þ¥©
§ï¤Ñ¨Ó¸Õ¸Õ¬Ý
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD