Use VBA add-ins and macros that you developed for Office for Windows with Office for Mac. Applies to: Excel for Mac PowerPoint for Mac Word for Mac Office 2016 for Mac. If you are authoring Macros for Office for Mac, you can use most of the same objects that are available in VBA for Office. Working with Files and Folders (Mac) Problems with Apple’s sandbox requirements and Mac Office 2016 and up with VBA code. Get path of Special folder. Check if File or Directory Exists. Make Directory if it not exist. Copy Folder in Microsoft Office for the Mac with VBA. Use VBA Kill to delete files. Use VBA to Delete all files in folder.

• Excel 2016 For Mac Download
• Excel 2016 For Mac Vba Tutorial
• Microsoft Excel 2016 For Mac
• Excel 2016 Mac Vba Debug

Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac

Key Points

• To clear content from a cell, you need to use the ClearContents method.
• You can use it for a single cell, a range, or an entire worksheet.

ClearContents Method

Excel 2016 For Mac Download

In VBA, there is a method called ClearContents that you can use to clear values and formulas from a cell, range of cells, and the entire worksheet.

To use this method, first, you need to define the expression somewhere you want to clear the content, and then type “.ClearContents”.

Clear Contents from a Single Cell

Let’s say if you want to clear values from the cell A1. First, you need to define the cell A1 using the range object and then the ClearContents method.

So the code would be:

You can also use the cells property to define a cell and the code would be:

Helpful Links: Run a Macro – Macro Recorder – Visual Basic Editor – Personal Macro Workbook

Clear Contents from a Range

In the same way, you can define a range and then use the ClearContent method to clear values and formulas from that range. Let’s say you want to clear values from the range A1:A10, in this case, the code would be something like below.

Clear Content from an Entire Worksheet

Excel 2016 For Mac Vba Tutorial

To clear content from an entire worksheet, you can use the below code:

And to clear from a specific worksheet:

Clear Content from the Selection

If you want to write a dynamic code that can clear contents from the selected cells, then you can use the below code.

Other Methods

Below are some of the other methods that you can use:

Microsoft Excel 2016 For Mac

• VBA Range – Useful Macro Examples – VBA Tutorial

Excel 2016 Mac Vba Debug