Vba Clear Worksheet Except First Row. Count] Clear contents is a method in VBA which is used to delete or remove the values which are stored in the cells provided to it, this method makes the cell Sometimes we delete a single cell value, sometimes many cells values, and sometime we may require to delete the entire worksheet content as well. From Excel VBA reference: When you delete a Workbook or Worksheet, this method displays a dialog box that prompts Range endRange = (Excel.
Description: Number of the first row (closer to the top of the worksheet) you want the macro to consider when identifying blank rows.
VBA-Excel: Clear data from Excel Sheet(WorkSheet).
The VBA code below can be copy/pasted to the VB Editor. If you simply want to delete the entire row from a specific row number to a specific row number, you can avoid using the Range and Cell. Clear Cells Range data in Excel Worksheet using VBA - An Example.