PapaDos,

I have tried to create other names, and then when putting in the main name,
the macro comes back with a run time error.

"PapaDos" wrote:

The "Refers to" property has a limit of 255 characters.

You can get around this limitation by defining the named range this way:
1 - Select all the cells you want to include in the named range
2 - Enter the name of the range in the "Name box" of the formula bar
(search Excel's help for "name range").
This technique works fine in Excel, but may cause surprises if you
manipulate the "Names" collection through VBA (rarely an issue).

Another way, is to create names for part of your range and use those names
to create the larger named range...


--
Regards,
Luc.

"Festina Lente"


"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