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