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

[µo°Ý] ¥~³¡¤Þ¤J¤§¸ê®Æ¦C¦Û°Ê±ø¾ã¦C°ª¤è¦¡½Ð°Ý

[µo°Ý] ¥~³¡¤Þ¤J¤§¸ê®Æ¦C¦Û°Ê±ø¾ã¦C°ª¤è¦¡½Ð°Ý

dear all ¤j¤j
1.¨Ï¥Î  ®æ¦¡-Àx¦s®æ-¹ï»ô¤è¦¡-¦Û°Ê¶Ã¦C µLªk­°¦C°ª¨Ì¤å¦r¦h¹è¦Û°Ê½Õ¾ã¦C°ª
2.½Ð°Ý¦p¦ó®Ñ¼g vba ¦Û°Ê½Õ¾ã¦C°ª?? °²³]¸ê®Æ©ó sheet1.¤§ AÄ椺
3.·Ð¤£§[½ç±Ð.
ù

¦^´_ 1# rouber590324
  1. Sub ex()
  2. Dim A As Range
  3. For Each A In Columns("A:A").SpecialCells(xlCellTypeConstants)
  4.   A.EntireRow.AutoFit
  5. Next
  6. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

DEAR Hsieh  ¤j¤j
THANKS  *10000
ù

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD