Question

excel表格怎样把批注批量导出来

Answer 1

如果都一样的话，不妨先插入一个，然后复制该单元格，选择批注都一样的单元格，点右键，选择性粘贴，选择批注，确定即可。如果不一样那只能用宏来做了，稍微麻烦点。

Answer 2

Sub test()
Dim rng As Range
Dim arr(10000, 1)
Set rng = Application.InputBox("请选择要提取的区域", "批注提取", Type:=8)
For Each rg In rng
If Not rg.Comment Is Nothing Then
arr(k, 0) = rg.Address
arr(k, 1) = rg.Comment.Text
k = k + 1
End If
Next
[a1].Resize(k, 2) = arr
End Sub
就是这么简单

Answer 3

这个问题很简单，百度一下就知道了