How to Copy Images from one cell to another using excel macro VBA ?

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 copy paste method you may find that the picture(s) or an image(s) in the cell is missing in the target cell.

Copy Images from one cell to another cell using excel macro VBA

 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, 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 copy method to copy images along with the content and select the Destination cell. Use 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 different sheet

First activate the source cell sheet and then select the source cell. Use copy method to copy the content. Activate the destination cell sheet and select the destination cell. Use 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

Excel 2016 Power Programming with VBA

Excel VBA 24-Hour Trainer

Excel VBA: A Beginners’ Guide

Leave a Reply