Rapidly Create a Large Number of Named Ranges

T

Thomas M.

Excel 2007

I have a spreadsheet with columns for each day of the week. The spreadsheet
is broken down into 5 sections. For each of the 7 columns I would like to
create a range name for the total in each of the 5 sections, so that would
be 35 range names in all.

Is there a way to quickly create range names? For example, could I create a
table containing the desired names for each range (which I could build with
an formula) and the corresponding address ranges, and then somehow use that
table to create all the range names?

Thanks for any help that you can offer?

--Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA concatenate ranges into a new document 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Proposal template with removable sections 0
Create a chart from a table in word thats dynamic 0
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Setting column width in a table with a macro is not working 0
Finding the right style field in VBA 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top