Our Service

Copying Pictures with a Macro in Excel

Excel is a powerful tool that can be used for a variety of tasks, from simple calculations to complex data analysis. One of the most useful features of Excel is the ability to automate repetitive tasks using macros. In this article, we will explore how to use macros to copy pictures in Excel.

What is a Macro?

A macro is a set of instructions that can be used to automate repetitive tasks in Excel. Macros can be created using the Visual Basic for Applications (VBA) programming language, which is built into Excel. Macros can be used to perform a wide range of tasks, from simple calculations to complex data analysis.

Copying Pictures with a Macro

Copying pictures in Excel can be a time-consuming task, especially if you need to copy multiple pictures. However, with a macro, you can automate this task and save yourself a lot of time.

Step 1: Create a Macro

The first step in copying pictures with a macro is to create a new macro. To do this, go to the Developer tab and click on the “Visual Basic” button. This will open the Visual Basic Editor.

In the Visual Basic Editor, click on “Insert” and then click on “Module”. This will create a new module where you can write your macro.

Step 2: Write the Macro

Now that you have created a new module, you can start writing your macro. The following code will copy a picture from one worksheet to another:

Sub CopyPicture()

Sheets(“Sheet1”).Shapes(“Picture 1”).Copy


End Sub

In this code, “Sheet1” is the name of the worksheet where the picture is located, “Picture 1” is the name of the picture, “Sheet2” is the name of the worksheet where you want to copy the picture, and “A1” is the cell where you want to paste the picture.

Step 3: Run the Macro

Once you have written your macro, you can run it by going back to the Excel worksheet and clicking on the “Macros” button on the Developer tab. This will open the Macros dialog box.

Select the macro you just created and click on the “Run” button. The macro will then run and copy the picture from one worksheet to another.


Using macros to copy pictures in Excel can save you a lot of time and effort. With just a few lines of code, you can automate this task and make your work much more efficient. So why not give it a try and see how much time you can save?


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.