Clear Used Range From Excel Using VBA

This snippit allows you to clear the contents of the used range on a excel sheet.

Sheets("CR Monthly Service Desk Calls").Rows("4:" & Sheets("CR Monthly Service Desk Calls").UsedRange.Rows.Count).ClearContents

Code Snippits