vba delete xlCellTypeVisible for row code example

Example: excel vba delete rows

' Removes 3rd row
ThisWorkbook.Worksheets(1).Rows(3).EntireRow.Delete
' Just clear cells without removing row
ThisWorkbook.Worksheets("Feuil1").Rows(3).Cells.ClearContents

' Removes 3rd row of a range
Range("My_RANGE").Rows(3).EntireRow.Delete