joshua-r2 of VBA Macros
10/5/2015 - 3:25 PM

Clear Rows

Clear Rows

'*******************************************************************************************************************************
'ClearRows
'   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