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

[µo°Ý] §R°£Àx¦s®æ¸ÌALT+ENTER©Ò³y¦¨ªº´«¦æ!!

[µo°Ý] §R°£Àx¦s®æ¸ÌALT+ENTER©Ò³y¦¨ªº´«¦æ!!

½Ð°Ý¦U¦ì¤j¤j¦³¤°»ò¤°»ò¿ìªk
©Î¬O¼g»yªk
¥i¥HÀx¦s®æ¸Ìªº´«¦æ(ALT+ENTER)§R°£±¼

¦^´_ 1# imzues


    Cells.Replace Chr(10), "", xlPart
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

©êºp¡A¤£¤ÓÀ´
§Ú¤W¶Ç¤@­Ó²³æªºÀÉ
¥i¥H¼gµ¹§Ú¬Ý¤@¤U¶Ü¡H
TEST.zip (1.31 KB)

TOP

¦^´_ 3# imzues

§Q°¨À°À°¦£
§âµ{¦¡½X©ñ¨ìµ{§Ç°õ¦æ¦Ó¤w
  1. Sub nn()
  2. Cells.Replace Chr(10), "", xlPart
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

SORRY ¤F¸Ñ¤F!!!!
·PÁÂ!!!!!

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD