Hi,
I have a macro which copies data from one sheet to another and saves before closing the workbook. Here I get an error before closing
"The picture is too large and can be truncated" I have used following method to clear the clipboard but it doesn't work and message error keeps appearing.
Please advise.
Sub ClearClipboard01()
Application.CutCopyMode = False
Application.CommandBars("Clipboard").Visible = True
On Error Resume Next 'incase clipboard IS empty
Application.CommandBars("Clipboard").FindControl(ID:=3634).Execute
Application.CommandBars("Clipboard").Visible = False
End Sub
Thanks in advance.
Regards,
P.S.
Bookmarks