Names may have limitations that string do not have. Try something like:


Sub sistence()
Dim CLEAR_OLD_DATA As String, r As Range
CLEAR_OLD_DATA = "A1:C9,A11:D13"
Range(CLEAR_OLD_DATA).Clear
End Sub

--
Gary's Student


"Sunnyskies" wrote:

Morning,

I wish to select 31 ranges and give them a name (CLEAR_OLD_DATA), but the
selection stops at 11 ranges, why?

They are all on one spreadsheet but are not in a specific column or row.

The purpose of the name is to group those cells that need to cleared when
the New Report macro is selected thus use the vba:
RANGE("CLEAR_OLD_DATA").CLEARCONTENT

So what can you advise?

Thanks