Clear contents and formatting of an Excel cell with a single command January 4, 2024 by Tarik Use the .Clear method. Sheets("Test").Range("A1:C3").Clear MSDN documentation here.