Try this, just drop this into VBA

Sub RemoveRange
Dim nm As Name

For Each nm In ActiveWorkbook.Names
Debug.Print nm.Name & " refers to " & nm.RefersTo
If InStr(1, nm.Name, "clr_") 0 Then
Range(nm.Name).ClearContents
End If
Next nm

End Sub