Menu
If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If you also want to clear the formatting, you can use .ClearFormats.
Sheets("Test").Range("A1:C3").ClearContents Sheets("Test").Range("A1:C3").ClearFormats If you want to do both, you can use .Delete, but then the other cells in the spreadsheet shift to replace the deleted cells.
Sheets("Test").Range("A1:C3").Delete How can you remove the contents and the formatting of a cell or range in VBA with a single command, without affecting the rest of the worksheet?
752
If you want to clear the contents of a cell or range in Microsoft Excel, you can use . ClearContents . If you also want to clear the formatting, you can use . ClearFormats .
The first way to clear content in Excel is to use the Clear Contents shortcut. To do this, simply select the cells you want to clear, then press the Ctrl + Shift + Del keys on your keyboard. This shortcut will instantly clear the contents of the selected cells.
You can clear all of the formatting from selected cells by first selecting the cells from which you want to remove all of the formatting. Then click the “Home” tab in the Ribbon. Then click the “Clear” button in the “Editing” button group.
Use the .Clear method.
Sheets("Test").Range("A1:C3").Clear MSDN documentation here.
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With