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

[µo°Ý] VBA¤¤.foumula«ç»ò¼g§t¦³""ªº¤½¦¡?

[µo°Ý] VBA¤¤.foumula«ç»ò¼g§t¦³""ªº¤½¦¡?

·Q­n±N¥H¤U¤½¦¡¼g¤JVBA¡A¨Ã¥Î°j°é¨Ó±±¨î¤½¦¡¤¤ªº¦C¼Æ¡A
sshot-179.jpg
¦ýcells.formula¤¤ªº¤½¦¡¤£¯à¦³""¡A½Ð°Ý¦³¨S¦³¤èªk¸Ñ¨M? ÁÂÁÂ!

"00"  §ï¦¨  ""00""
¥Î¿ý»s§Y¥i¬Ý¥X®t²§~~

TOP

¦^´_ 1# chiata


    ¥Î2­Ó¤Þ¸¹¨ú¥N1­Ó¤Þ¸¹¡A¹³³o¼Ë
  .Cells(factor_count, 5).Formula = "=TEXT(A1,""00"")&B1&TEXT(C1,""000"")&D1"

TOP

·PÁÂ~¤w¶¶§Q¸Ñ¨M¡A¤@®É¨S·Q¨ì¥i¥H¥Î¿ý»s¡AÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¥Ç¿ù¥XÄb®¬¤ß¡A¤~¯à²M²bµL·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD