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

[µo°Ý] °ÝÃD¡G¦p¦ó±j¨î ±±¨îÅv¨ì sheet1¤W©O ?ÀYµh¤¤

[µo°Ý] °ÝÃD¡G¦p¦ó±j¨î ±±¨îÅv¨ì sheet1¤W©O ?ÀYµh¤¤

°ÝÃD¡G¦p¦ó±j¨î ±±¨îÅv¨ì sheet1¤W©O ?

±¡ªp¬O¡A§Ú§Æ±æµ{¦¡ ¤@ª½¦bsheet1 ¶]¡A¥i¬O¦³®É§Ú·|¥hÂI EXCEL ¤Wªºchart °ÊºAø¹Ïª«¥ó¡C(chart¬O®Ú¾Úsheet1¤Wªº¸ê®Æø¹Ï)

ÂI¤F¤§«á¡A±±¨îÅv´N¶]¨ìchart ª«¥ó¤W¤F¡C¤§«á  ¥u­n¦³§ó·s¸ê®Æ¡A´N·|¥X²{ "row¤èªk"('_global ª«¥ó') ¥¢±Ñ~~

·íµM ¡A¦pªG±±¨îÅv¦b sheet1¤W¡A´N¥þok ¡C

Sub updateFollow()
       Sheet1.Range("a" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[a2]  (¨C¦¸³£¿ù³o¤@¦æ)
       Sheet1.Range("b" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[b2]
       Sheet1.Range("c" & Rows.Count).End(xlUp).Offset(1) = Sheet1.[c2]

End Sub

·d©w¤F¡Aµ²½×´N¬O¡K¡K

¤£­n¦b¥¿¦b¦¬¸ê®Æ®É¡A¥h¸I¹Ï´N¹ï¤F ><

¦n¶H¤]¥u¯à³o¼Ë ><

TOP

¦^´_ 2# lbt


    Sheet1.Range("a" & Sheet1.Rows.Count).End(xlUp).Offset(1) = Sheet1.[a2]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD