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

[µo°Ý] ¦X¨Ö¤å¦rÅܼƭȦp¦ó¼g?

[µo°Ý] ¦X¨Ö¤å¦rÅܼƭȦp¦ó¼g?

½Ð°Ý·Q­n±N©w¸q¦WºÙªº¤º®e»P¤£¯S©w¤§¤å¦rÅܼƭȦX¨Öªí¹F©ó¤@­ÓÀx¦s®æ¤º¡AVBA»yªk¸Ó¦p¦ó½s¼g?
¦Û¤v¸Õ¹L¥ÎCONCATENATE¤½¦¡¤Î & ¨âºØ¤èªk¡A¦ý¬O¤å¦rÅܼƪº­È¤@ª½µLªk°µ¥X¦Û¤v·Q­nªºµ²ªG¡C
½Ð±Ð¦U¦ì°ª¤â¸Ó¦p¦ó¸Ñ¨M?ÁÂÁÂ!!

¦X¨Ö¤å¦r»P¼Æ¦r.rar (6.97 KB)

¦¨¥\¤F,ÁÂÁÂHsiehªº§ï¥¿

TOP

¦^´_ 1# voyageellen


    §A­nªº¬O¼g¤J¤½¦¡¦r¦ê¶Ü?
  Cells(1, 4).Formula = "=¦~«×-1&""¦~""&""" & Month & """"
  Cells(2, 4).Formula = "=CONCATENATE(¦~«×-1,""¦~""," & """" & Month & """)"
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD