Excel macro to extract comments: 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:3416:34, 20 November 2024‎ Mwroot talk contribs‎ 4,637 bytes +4,637‎ Created page with "{| class="wikitable" ! 我 || 通义千问 |- | 你是一个excel专家。请用宏把 D 列单元格的批注，保存到 I 列对应行，无批注的行不用管 | 在Excel VBA中，你可以创建一个宏来实现这个功能。以下是一个简单的示例： <syntaxhighlight lang="VBScript" line> Sub CopyCommentsToColumn() Dim ws As Worksheet Dim rng As Range Dim cell As Range '设置你要操作的工作表 Set ws = ActiveSheet '设..."
Retrieved from "https://qingliezhiquan.com/blog/Excel_macro_to_extract_comments"