VBA ClearContents / Clear Cells
In this Article
In VBA it’s easy to clear cells or cell properties with the .Clear methods.
VBA Clear Cells / Ranges
Type the following into the VBA Editor.
1 |
Range("a1").Clear |
This will display all of the Clear methods available to you:
As you can see, You can clear:
- Everything ( .Clear)
- Comments ( .ClearComments)
- Contents ( .ClearContents)
- Formats ( .ClearFormats)
- Hyperlinks ( .ClearHyperlinks)
- Notes ( .ClearNotes)
- Outline ( .ClearOutline)
VBA ClearContents
The most common clear method is ClearContents. ClearContents clears only the contents of cells (cell values / text). It does not clear formatting, comments, or anything else.
1 |
Range("b2").ClearContents |
ClearContents is the same as pressing the Delete key on your keyboard.
You can also clear the contents of an entire range of cells:
1 |
Range("b2:c10").ClearContents |
VBA Clear
Clear will clear all cell properties from a cell:
1 |
Range("b2").Clear |
VBA Clear Formatting
To clear cell formatting use ClearFormats
1 |
Range("b2").ClearFormats |
Clear Selection
To clear the current selection:
1 |
Selection.Clear |
Clear Entire Sheet
1 |
Sheets("Sheet1").Cells.Clear |
VBA Coding Made Easy
Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!
Learn More!