10/12/2017 - 5:46 PM

Clear Rows x to y

Clears rows for a given start and end row. Combine with GetLastRow function to clear a range from a given row on

'   Purpose: Given a worksheet, a start, and and end row clears the sheets values.

Public Sub ClearRowsOfSheet(wsClearSheet As Worksheet, lStartRow As Long, lEndRow As Long)

With wsClearSheet
    .Range(.Cells(lStartRow, 1), .Cells(lEndRow, 1)).EntireRow.Clear
End With

End Sub