Convert Selected Range into an Image Using Macros in Excel 365!!
Tags: vbamacros, convertselectedrange
Published: 2020-10-03 10:55:20

---
title: Convert Selected Range into an Image Using Macros in Excel 365!!
published: true
date: 2020-10-02 12:22:38 UTC
tags: VBAMacros,ConvertSelectedRange
canonical_url: https://geekexcel.com/convert-selected-range-into-an-image-using-macros-in-excel-365/
---

## Convert Selected Range into an Image Using Macros:

In this guide, we are going to explore how to **Convert Selected Range into an Image Using Macros in Excel Office 365**. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to Convert Selected Range into an Image Using Macros:

Here are the steps to convert the selected range into an image using Macros, do as follows.

- In the below screenshot, you can see the **input text string** in the **cell B2** , and we are going to convert this text into an image.

![Example text string](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-2.png)<figcaption id="caption-attachment-14991">Example text string</figcaption>

- On the **Developer Tab, select** the **Visual Basic** option under the **Code** section.

![Select Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Visual-Basic-option-5.png)<figcaption id="caption-attachment-14839">Select Visual Basic option</figcaption>

- You need to activate the sheet where you have the input text string.
- Kindly, **enter the below code**.

VBA code for Converting selected range into an image using Macros in Excel

‘Make sure that the input range is selected

Sub ConvertSelectedRangeIntoAnImage()

Selection.Copy

‘You need to paste the selection as an image

ActiveSheet.Pictures.Paste.Select

End Sub

- You need to **save the code** by selecting it. Then close the window.

![Enter the Source Code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Enter-the-Source-Code.png)<figcaption id="caption-attachment-14992">Enter the Source Code</figcaption>

- You need to open the sheet containing the data. On the **Developer Tab, choose** the **Macros option** in the **Code** section.

![Choose the Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-the-Macros-option-3.png)<figcaption id="caption-attachment-14841">Choose the Macros option</figcaption>

- You need to make sure that your macro is selected and **click** the **Run** button.

![Macro dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Macro-dialog-box.png)<figcaption id="caption-attachment-14993">Macro dialog box</figcaption>

- Now, the text string is converted into an image format. You can rotate it or resize it as you wish.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-2.png)<figcaption id="caption-attachment-14994">Output</figcaption>

## Wind-Up:

In this guide, you can clearly understand the steps to **Convert Selected Range into an Image Using Macros in Excel Office 365**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [Convert Excel to PDF Using Macros (VBA) in Excel 365 – (Quick Ways)](https://geekexcel.com/convert-excel-to-pdf-using-macros-vba-in-excel-365-quick-ways/)
- [**Unmerge All Cells Using Macros**](https://geekexcel.com/unmerge-all-cells-using-macros-vba-in-excel-office-365/)