have I misunderstood Range.Clear?

[Shakeable_Drip]

I have a range called "clean" on my worksheet that I'd like to clear with VBA.
"clean" is a named range, A2:E1000&G2:G1000
I thought this was fairly simple, but I think I've misunderstood how something works. Debug doesn't like the Set CLEANS. I thought it was a conflict in name, I changed it to cleans and still no joy. Double checked for typo's

Sub CLEAN_UP()
Dim SHT1 As Worksheet
Dim CLEANS As Range
Set SHT2 = Sheets("DATA INPUT")
Set CLEANS = Range("CLEAN")
CLEANS.Clear

End Sub

 

[RoryA]

Where is this code, and exactly how is the CLEAN range defined? Workbook level, or worksheet-level?

 

[Shakeable_Drip]

WorkSheet level,

='DATA INPUT'!$A$2:$E998&'DATA INPUT'!$G$2:$G$1000

Fixed the missing "$", still fails.

='DATA INPUT'!$A$2:$E$1000&'DATA INPUT'!$G$2:$G$1000

 

[RoryA]

That’s not a range, it’s an array created by concatenation of the values in those two ranges.

 

[Shakeable_Drip]

Awwee face palm that makes sense, Thanks.
My skills are limited, but I can split "clean" into 2 parts "clean1" range A2:E1000 and "Clean2" range G2:G1000 and clear them separately.
Maybe there is a better way?

 

[Shakeable_Drip]

Thanks again, its ugly, but works

Sub CLEAN_UP()
Dim SHT1 As Worksheet
Dim CLEANS1 As Range, CLEANS2 As Range
Set SHT2 = Sheets("DATA INPUT")
Set CLEANS1 = Range("CLEAN1")
Set CLEANS2 = Range("CLEAN2")

CLEANS1.Clear
CLEANS2.Clear

End Sub