Cutting and pasting in Microsoft Office applications saves you untold hours in typing and retyping data and text. If you are like many business users of Microsoft Excel, you probably perform countless ...

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.