ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change the contents of a Named List (https://www.excelbanter.com/excel-worksheet-functions/187592-how-do-i-change-contents-named-list.html)

Bryan

How do I change the contents of a Named List
 
I have a list, say 50 cells, named "Charlie". I want to add to extend that
named list to by 60 cells. How do I do this in Excell 2003?

Gaurav[_3_]

How do I change the contents of a Named List
 
Select the range. go to InsertNameDefine. Now change the range you see in
"refers to" box.

Is that what you wanted to do?


"BRyan" wrote in message
...
I have a list, say 50 cells, named "Charlie". I want to add to extend that
named list to by 60 cells. How do I do this in Excell 2003?





All times are GMT +1. The time now is 06:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com