Say you’re processing a bunch of information and you need to clear a sheet.
' Delete any/all records
If (ActiveSheet.UsedRange.Rows.Count) > 1 Then
lngResRng = ActiveSheet.UsedRange.Rows.Count
Say goodbye to everything in the sheet from A2 to A65000 – all rows will be deleted.