I'm trying to use VBA to copy images in a Word doc and paste-special as JPEG or bitmap. I've found a bit of code and made it work, but I cannot find an adequate explanation of what I am doing.
It’s not easy to fool Excel, but with a few extra clicks, you can work around this odd pasting behavior. If you paste formatted values into a cell with another applied format, the pasted format wins.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results