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

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

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

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