|
Sub test()
Dim i
Application.ScreenUpdating = False
ActiveSheet.Pictures.Delete
For i = 2 To Cells(Rows.Count, 2).End(3).Row
If Trim(Cells(i, 2)) = "小组" Then
Cells(i, 2).CurrentRegion.CopyPicture
Call test2
Cells(i, "J").PasteSpecial
End If
Next
[a1].Select
End Sub
Sub test2()
Dim aFmts, fmt
'以数字数组的形式返回剪贴板中当前的格式
aFmts = Application.ClipboardFormats
For Each fmt In aFmts
Debug.Print fmt
Next
End Sub
测试3.rar
(19.38 KB, 下载次数: 1)
|
|