Thread: Named range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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