View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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