Multiple Names in refers to field of Define Name

S

Sunnyskies

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.
 
O

Otto Moehrbach

What you want is not clear. You say you have multiple names. Are these
range names or simply entries in cells?
You say you want to "combine" all the names. What do you mean by "combine?
Please post back and provide more detail about what you have and what you
want to have. Remember that no one who reads your post has any knowledge
whatsoever about your business. HTH Otto
 
B

Bob Phillips

Don't start a new thread, your previous one is still being responded to, and
benefits that it has the history of the problem.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
D

Dave Peterson

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
 
Top