| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named range
I have created some lists in my spreadsheet. These lists are named ranges (I think).
How can I add more cells to a named range? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named range
Mark,
Press Ctrl+F3 to bring up the Define Name dialog box. In that dialog, select the name whose range you wish to change, and change the Refers To range at the bottom of the dialog. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mark" wrote in message ... I have created some lists in my spreadsheet. These lists are named ranges (I think). How can I add more cells to a named range? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named range
for a single column vertical range name List:
range("List").Resize(range("List").Rows.Count+3).N ame = "List" adds 3 cells to the bottom of the list. -- Regards, Tom Ogilvy "Mark" wrote in message ... I have created some lists in my spreadsheet. These lists are named ranges (I think). How can I add more cells to a named range? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Named range
Yes, it did the trick. Thanks
"Chip Pearson" wrote: Mark, Press Ctrl+F3 to bring up the Define Name dialog box. In that dialog, select the name whose range you wish to change, and change the Refers To range at the bottom of the dialog. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mark" wrote in message ... I have created some lists in my spreadsheet. These lists are named ranges (I think). How can I add more cells to a named range? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
| Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Linear Mode
