All public logs

Combined display of all available logs of 清冽之泉. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

Logs
  • 16:35, 20 November 2024 Mwroot talk contribs created page Excel macro to count comments in a workbook (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 ' 遍历工作簿中的所有工作...")