Thread: Named range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default 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