ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD