Insert-Name-Define limit ?
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
|