Specified format doesn't match format of data (Error 461)
The specified Clipboard format is incompatible with the method being executed. This error has the following causes and solutions:
You tried to use the GetText method or SetText method with a Clipboard format other than vbCFText or vbCFLink. Before using these methods, use the GetFormat method to test whether the current contents of the Clipboard matches the specified format.
You tried to use the GetData method or SetData method with a Clipboard format other than vbCFBitmap, vbCFDIB, or vbCFMetafile. Before using these methods, use the GetFormat method to test whether the current contents of the Clipboard matches the specified graphics format.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.