Did you try Roger's suggestion:

Create separate ranges for each of the building blocks.

Then insert|Name|define
Names in Workbook: Clear_Old_Data
refers to: =clear_old_data_BVO,clear_old_data_cleanup

(and keep going--just separate each name with a comma)

======
But if you're using this in code, why not just:

range("Clear_Old_Data_BVO").clearcontents
range("Clear_Old_Data_Cleanup").clearcontents
And keep going...

or even

union(range("Clear_Old_Data_bvo"),range("Clear_Old _Data_Cleanup"), _
range(....), range(...), ....).clearcontents



Sunnyskies wrote:

Afternoon,

I have got multiple names:
Clear_Old_Data_BVO
Clear_Old_Data_Cleanup
Clear_Old_Data_Dates
Clear_Old_Data_Header
Clear_Old_Data_HR
Clear_Old_Data_Incident

I want to combine all these names under one: Clear_Old_Data

I cannot put all the various cell ranges under Clear_Old_Data, as it only
allows me to select 11 ranges. That is why I created various Names.

Your assistance would be appreciated.

--

Dave Peterson