å¯ä»¥è¯ä¸ä¸ä»¥ä¸æ¹æ³ï¼
1.æå¼éè¦å¤ççExcelå·¥ä½ç°¿
2.å³é®ç¹å»ä¸ä¸ªç©ºç½çè¡¨æ ¼çå称ï¼éæ©âæ¥ç代ç (V)â
3.å¨å¼¹åºç页é¢ç©ºç½å¤ç²è´´ä»¥ä¸ä»£ç ã
4.ç¹å»è¿è¡(æç´æ¥æåè½é®F5)
5.è¥è¯¥é¡µA1åå
æ ¼ä¸ºç©ºï¼åå¨A1å¤æ¾ç¤ºæ´ä¸ªå·¥ä½ç°¿çæ¹æ³¨ï¼å¦åå¼¹åºçªå£æ¾ç¤ºã
6.å¤å¶A1åå
æ ¼å
容å°wordï¼å³å¯ã
'******代ç å¼å§*****
Sub a()
For Each sh In Sheets
For i = 1 To sh.Comments.Count
s = s & Chr(10) & sh.Comments(i).Text
Next
Next
if [A1] = "" then
[A1]=s
else
msgbox s
end if
End Sub
'******代ç ç»æ*****
温馨提示:答案为网友推荐,仅供参考