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

[µo°Ý] Excel Àx¦s®æ¤@°Ý

[µo°Ý] Excel Àx¦s®æ¤@°Ý

½Ð°Ý¡A¦p¦ó±NExcel Àx¦s®æ³]©w¦¨{¥u¯à¶K¤W­È}¡H
¤£ºÞ¬O¥Î¨ç¼ÆÁÙ¬OVBA¡A½Ð°Ý¸Ó¦p¦ó¹F¦¨?

¦^´_ 1# zz0660


    ½Ð°Ýª©¤j¬O­n°Ý¦p¦ó±N¤½¦¡¥t¦s¦¨­È´N¦n¶Ü?

    ¦pªG¬Oªº¸Ü¡A¤èªk¦p¤U3±i¹Ï¶¶§Ç¡G
1.¥ý½Æ»s


2.«ö·Æ¹«¥kÁä¡A¿ï¿ï¾Ü©Ê¶K¤W


3.¿ï  ­È

TOP

¦^´_ 2# jeffrey628litw


    ³o­Ó§Ú¤w¸gª¾¹D¤F¡A¦ý¤£·Q­n¨C¦¸¶K¤W³£¦p¦¹½ÆÂø¡C
§Ú·Q­nªº¬O¤@­Ó¶K¤W°Ê§@¡A´N¯àª½±µÂন­È¡C

¤£¹LÁÙ¬O·PÁ±zªº¤À¨É¡C

TOP

­Y¬O­n§@«Ü¦h¦ì¸m¥i¥H¼g¦¨VBA
¨Ò¦p
Sub ½Æ»s¶K¤W()
    ½Æ»s = "F2:F4 F5:F6 F7": CP = Split(½Æ»s)
    ¶K¤W = "G2:G4 H5:H6 I7": PS = Split(¶K¤W)
    For I = 0 To UBound(CP)
        Range(PS(I)) = Range(CP(I)).Value
    Next
End Sub
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

±N"¶K¤W­È"¹Ï¥Ü©Ô¨ì¥\¯àªí¤W¤è§Y¥i(¦Û­q¤u§@¦C)

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD