Sub ClearData() Worksheets("Clients").Rows("2:" & Rows.Count).ClearContents Worksheets("Cases").Rows("2:" & Rows.Count).ClearContents Worksheets("Sessions").Rows("2:" & Rows.Count).ClearContents End Sub
Sub ClearData() Worksheets("Clients").Rows("2:" & Rows.Count).ClearContents Worksheets("Cases").Rows("2:" & Rows.Count).ClearContents Worksheets("Sessions").Rows("2:" & Rows.Count).ClearContents End Sub