How to Copy Images from one cell to another using excel macro VBA ?
When we copy images or any data from the cell there may be a chance that the cell can contain pictures or images along with the text or numeric values. When you use VBA to perform the copy paste method you may find that the picture(s) or an image(s) in the cell is missing in the target cell.
Solution
If you want to copy all the objects such as text, images, and string from one cell and paste it into another cell, then you should select the source cell first. After selecting the source cell, use the copy method to copy all the objects inside the cell. Then, use the select method to select the target cell and paste the copied values.
Condition
Make sure that no part of the image extends out of the source cell. Adjust the size and fit it into the source cell ( Say A1) before executing the macro. Otherwise, the macro will not work
Different Methods
1. VBA Copy paste Images from one cell to another cell on the same sheet
First, activate the sheet and select the source cell. Use the copy method to copy images along with the content and select the Destination cell. Use the Paste method to paste it in the destination cell.
Related Post: Speed up Excel VBA macro by 300% just by adding two functions
2. VBA Copy paste Images from one cell to another cell on a different sheet
First, activate the source cell sheet and then select the source cell. Use the copy method to copy the content. Activate the destination cell sheet and select the destination cell. Use the Paste method to paste it in the destination cell.
Check out the video tutorial
Please let me know your doubts via comments
Recommended Excel VBA books
About The Author
Rajan
Rajan is a web geek-Blogger-Programmer- working in corporate firm as system analyst engineer. Whenever time permits he used to blog on recent trends in technology, monetizing tips, Programming concepts and technical guides to beginners in amarindaz.
I want to thank you! I have been working on this for 5 days straight and your information Herr was the final lesson to make it all come together!! Was exactly what I was looking for. Thank you again!