Clear Multiple Cells Or Ranges On A Worksheet

less than 1 minute read This joins many addresses together as a string, picks up a defined named range “sNamedRange” and clears the contents from the cells. ‘================================================================================================== ‘ ## Clear data from multiple ranges ‘================================================================================================== Sub ClearReportData() ‘ // vars Dim sNamedRange As String sNamedRange = Range(“sNamedRange”).Address Dim strCells As String strCells = “E6:E8, … Read more