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