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

[µo°Ý] ¥i§_¥Îªí³æ¤è¦¡¨Ó«Ø¥ß¸ê®Æ®w?

Private Sub Cbo·s¼W¸ê®Æ_Click()
     myarray = Array(Txt©m¦W.Value, Txt¹q¸Ü.Value, Txt¦a§}.Value)
    [b65536].End(xlUp).Offset(1).Resize(, 3) = myarray   ===>½Ð°Ý¥ªÃä³o¦æµ{¦¡½X,¥i§_À°¸ÑÄÀ¤@¤U!!
    If Range("A2") = "" Then
        Range("A2") = 1
        Range("A2:A" & Range("B65536").End(xlUp).Row).DataSeries===>½Ð°Ý¥ªÃä³o¦æµ{¦¡½X,¥i§_À°¸ÑÄÀ¤@¤U!!
    Else
        Range("A" & [a65536].End(xlUp).Row & ":A" & Range("B65536").End(xlUp).Row).DataSeries     ===>½Ð°Ý¥ªÃä³o¦æµ{¦¡½X,¥i§_À°¸ÑÄÀ¤@¤U!!
    End If
End Sub

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD