Excel macro to count comments in a workbook: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

6 December 2024

20 November 2024

  • curprev 16:3516:35, 20 November 2024‎ Mwroot talk contribs‎ 1,102 bytes +1,102‎ Created page with "无权要求其改变工作习惯的同事，喜欢在单元格上用注释，要计算他搞了多少条注释，手动数是不切实际的，Kimi.ai 写一段宏解决了此问题。 <syntaxhighlight lang="VBScript" line> Sub CountCommentsInAllSheets() Dim wb As Workbook Dim ws As Worksheet Dim count As Integer Dim totalComments As Integer Set wb = ThisWorkbook count = 0 totalComments = 0 ' 遍历工作簿中的所有工作..."
Retrieved from "https://qingliezhiquan.com/blog/Excel_macro_to_count_comments_in_a_workbook"