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

¦p¦ó§PÂ_Àx¦s®æ¬O§_´«¦æ

¦p¦ó§PÂ_Àx¦s®æ¬O§_´«¦æ

¦U¦ì¹F¤H:
¤p§Ì»s§@ªí®æ®É¦]¬°Àx¦s®æªº¤º®eªøµu¤£¤@,¤S¥Î¦Û°Ê´«¦C¡A¦]¦¹¨Ï¥ÎAutofit«á·Pıªí®æ«Ü¶Ã
¦]¦¹·Q­n³W«h¤ÆÀx¦s®æªí®æ¬üÆ[¤@ÂI¡A¦]¦¹·Q­nÅý¨S¦³¦Û°Ê´«¦CªºÀx¦s®æ¦C°ª³£²Î¤@
©Ò¥H·Q½Ð°Ý¦p¦ó§PÂ_Àx¦s®æ¤ºªº¤º®e¬O§_¶W¹L¤@¦C?©Î¬O¦p¦óª¾¹DÀx¦s®æ¬O§_¦³´«¦æ?

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-11-28 14:58 ½s¿è

¦^´_ 1# modelcrazyer


    ´«¦C? ¤À¦æ?





½Ð°Ý¦p¦ó§PÂ_Àx¦s®æ¤ºªº¤º®e¬O§_¶W¹L¤@¦C?©Î¬O¦p¦óª¾¹DÀx¦s®æ¬O§_¦³´«¦æ

¨Ì¾Ú?  ¦p ¤@¦æ¤º­n´X­Ó¦r¡H ©Î  ¦V¥ª ¥k°¾? ¸m¤¤?

  ¦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

¬O²Ä¤GºØ,¦]¬°Àx¦s®æ¤j¤p¤w©T©w¤F!!

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-11-28 15:43 ½s¿è

¦^´_ 1# modelcrazyer


¥H¹Ï¬°¨Ò¡A¤À§O10­Ó°ê¦r¬°¤À¬q ¡A¦¹¤èªk¬°²Ä¤@ºØ¡C



­Y¶·²Ä¤GºØ¡A­n¥ý§PÂ_
¹w³]Àx¦s®æ ¼e¡B °ª ¬°¦ó¡H ¦rÅé¤j¤p¬°¦ó¡H  ³æ¦æ¦r¼Æ¬°¦ó¡H

  ¦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

ÁÂÁ±z¼ö¤ß¦^µª¡A
¦^À³±zªº´£°Ý¡A¥Ø«eÀx¦s®æ¼eª¾¹D,¦rÅé¤j¤pª¾¹D,³æ¦æ¦r¼Æ¦]¬°¤º®e§t¦³²Å¸¹,©Ò¥H¦r¼Æ´N¬O¤£ª¾¹D­n«ç»ò©T©w¬GµLªk§PÂ_,¦Ü©óÄæ°ª§Ú±N¨Ó·|¼g§PÂ_¦¡¦pªG¬O³æ¦æ·|Åý¥¦©T©w¡A¦h¦æªº¸Ü«h·|¥ÎAutofit²£¥Í,©Ò

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-11-28 16:17 ½s¿è

¦^´_ 5# modelcrazyer


¥ý«e¦³¶K¹L¨â±i¹Ï©M ¤@¬qµ{¦¡
´N¬O²©ö§PÂ_

¨Ò¦p
1. If Cells(sii, 1) <> "" Then Cells(sii, 2) = Len(Cells(sii, 1))
³o¬q·N«ä¡A´N¬O¤£ºÞ AÄæ¦ì ¤º®e¬O ¼Æ¦r ¤å¦r ²Å¸¹ ³£¦bBÄæ¦ì¤º Åã¥ÜÁ`¦r¼Æ¡A¥H«K¦Û¦æ¬ã§P¡C

2.³æ¦æ©T©wªº¸Ü¡A´N¨ú¤j¬ù­È¡C
¥H¥¿±` ¨Ó»¡(¦Û°ÊºòÁY«á¼e«×)
­YÀx¦s®æ¤º   ¤å¦r ³æ¤@­Ó¦r  ¼e«×¬ù¬° 2.88   (³æ¦ì§Ú´N¤£¼g   
                       ¤å¦r ¨â­Ó¦r¥H¤W <¦p 7­Ó¦r ¼e«×¬ù¬° (2*7 )+ 0.88>
                      ¥b§Î²Å¸¹  ¼e«×¬ù¬° 1.88
                      ¥þ§Î²Å¸¹  ¼e«×¬ù¬° 2.88

Á|¨Ò ¡G [A1]  = ¡·¢{¤¤µØ¥Á°ê¢z¡·     ¼e«×¬ù¬°  17.75  < ¦]¬° EXCEL ¦³¹w³] ºòÁY¦r¤¸ >
              [B1]  = ¡·¤¤µØ¥Á°ê¡·            ¼e«×¬ù¬°  13.25 < ¦]¬° EXCEL ¦³¹w³] ºòÁY¦r¤¸ >
              [C1]  =¤¤µØ¥Á°ê                 ¼e«×¬ù¬° 8.88 <(4*2 ) +0.88>

  ¦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

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2012-11-28 19:15 ½s¿è

¦^´_ 5# modelcrazyer
ÀˬdÀx¦s®æ¬O§_¦³¤Ä¿ï¦Û°Ê´«¦æ:  
If Range("A1").WrapText=true then
...

ÀˬdÀx¦s®æ¤¤ªº¦r¤¸¬O§_¦³´«¦æ¦r¤¸ , ¹³¬OAlt+Enter²£¥Íªº´«¦æ
If InStr(1, Range("A2"), vbLf)>0 then
...

§Úªº¸Ü, ·|¦Ò¼{´«¦æ¦r¤¸³£¨ú¥N±¼, ¤Ä¿ï¦Û°Ê´«¦æ, ¤â°Ê½Õ¾ãÄæ¼e, ¦C°ª¥Îautofit

TOP

ÁÂÁ¨â¦ìªº¦^µª,«á¨Ó¥Îtry and errorªº¤èªk¥ÎLen¨ç¼Æ,§PÂ_¤@¦æ¤j·§´X­Ó¦r¤¸

TOP

¦^´_ 8# modelcrazyer


    ¤@¦æ´X­Ó¦r¤¸¬Ý¼e«×¦Ó©w¡AÂà¹L¨Ó»¡ ¤µ¤Ñ¤@¦æ§Ú­n30­Ó¦r¤¸¡A¦ý§Ú¥u­n¤Ï¹L¨Ó³]©w30¦r¤¸ªº¼e«×

  ¦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

ÁÂÁÂ,¦]¬°ª©­±ªºÃö«Y,©Ò¥H¨C­ÓÀx¦s®æ¼e«×¬O©T©wªº¡A¦ý¬O°ª«×¤£©T©w¡A©Ò¥H¥u¯à±q¦r¤¸¼Æ¨Ó§PÂ_¡A¥»¨Ó¬O·Q¥ÎChr(10)©Î¬OChr(13)¨Ó§PÂ_,¦ý¬O¦]¬°¬O¦Û°Ê´«¦C¦Ó«D±j­¢´«¦C©Ò¥H¦³§ä¤£¨ìChr(10)©Î¬OChr(13)³o¨â­Ó±±¨î½X

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD