Okay, need some guidenance.

Here are my list of name:
Clear_Old_Data_BVO
Clear_Old_Data_Cleanup
Clear_Old_Data_Dates
Clear_Old_Data_Header
Clear_Old_Data_HR
Clear_Old_Data_Incident

Now the main name is Clear_Old_Data

In the Refers to field what do I type there?

Thanks

"PapaDos" wrote:

You probably made an error in defining the names.
It should work OK.

Post a simplified example of what you did...

--
Regards,
Luc.

"Festina Lente"


"Sunnyskies" wrote:

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