- ©«¤l
- 4
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 5
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- 7
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-4-10
- ³Ì«áµn¿ý
- 2013-4-16
|
[µ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¤§«á ¥un¦³§ó·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 |
|