ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   List deleting or changing (https://www.excelbanter.com/new-users-excel/133209-list-deleting-changing.html)

Asiageek

List deleting or changing
 
I have a list of data that was given a name to an area of data though I've
added more data (rows) and the list doesn't work with the new data added and
reverts back to the original named list regardless of row additions anywhere.

How do I change the range of data named to cover the extra data/rows added?
i can't seem to find the right information about this.

Thank you.

Max

List deleting or changing
 
Try Debra's page at:
http://www.contextures.com/xlNames01.html#Dynamic
Create a Dynamic Range
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Asiageek" wrote:
I have a list of data that was given a name to an area of data though I've
added more data (rows) and the list doesn't work with the new data added and
reverts back to the original named list regardless of row additions anywhere.

How do I change the range of data named to cover the extra data/rows added?
i can't seem to find the right information about this.

Thank you.



All times are GMT +1. The time now is 03:59 PM.

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