Skip to main content

Snip a Range to Clipboard With a Macro Button in Excel for Mac

Joshua earned an MBA from USF and he writes mostly about software and technology.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Suppose you have a range that you usually have to snip in Excel but you don't like using the snipping tool. You can automate this process with a few easy steps. In this tutorial, I will use Excel for Mac, but some processes will be the same for Windows users.

Let's use the above photo as an example. I would like to copy a photo snip of that range of data to the clipboard. To start, I need the developer tab to be available. To make the developer tab available you must first go to the Excel options tab and click preferences.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Next, choose the ribbon and toolbar option.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Click on one of the options in the main tabs area and tap the down arrow until you find the developer tab option. Check the box and click save.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Choose the developer tab and click on the form control button labeled as button under its button-shaped icon.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Click in the area of the worksheet where you would like the button to appear and the assign macro window will appear. Give the macro a name with no spaces (or keep the default) and click record.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

This automation will execute when a button is pressed but you may also assign a keyboard shortcut to the macro as well here. Press OK to begin recording the process.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Select the range and copy it.

Scroll to Continue
snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Select a cell anywhere in the spreadsheet to temporarily post a picture of the range by selecting paste special followed by paste picture.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Next, cut the picture from the spreadsheet.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Stop recording the macro by clicking on the stop button in the lower left-hand corner of the spreadsheet.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Now you can test the button by changing the data in the cell and clicking on the button. Paste the picture into a cell.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

You make modify the code to select another range by going to the macro icon on the developer tab or the view tab.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Select the macro followed by the edit button.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Here the range that is copied can be modified to whatever range needs to be copied in the worksheet.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Be sure to save the workbook as a macro-enabled workbook by going to file and saving the document with a .xlsm extension as shown in the image below.

snip-a-range-to-clipboard-with-a-macro-button-in-excel-for-mac

Use a Macro Button to Save a Picture of a Range to Clipboard in Excel for Mac

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2022 Joshua Crowder

Related Articles