ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Deleting or Renaming Lists (https://www.excelbanter.com/excel-discussion-misc-queries/69506-re-deleting-renaming-lists.html)

Max

Deleting or Renaming Lists
 
"Tail Wind" wrote:
I have made a list but I now need to make changes. If I could delete the
list name and associated range (but not the data obviously) I would just
start over.


If you're referring to named / defined ranges,
the options to delete, amend, etc can be accessed
via clicking Insert Name Define

Eg: To delete an named range, just select it within
the Define Name dialog, then click Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Tail Wind

Deleting or Renaming Lists
 
Thank you so much Max. That was sooo easy I'm sick! I just couldn't locate
the solution until you helped out.

Thanks again.


"Max" wrote:

"Tail Wind" wrote:
I have made a list but I now need to make changes. If I could delete the
list name and associated range (but not the data obviously) I would just
start over.


If you're referring to named / defined ranges,
the options to delete, amend, etc can be accessed
via clicking Insert Name Define

Eg: To delete an named range, just select it within
the Define Name dialog, then click Delete
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Max

Deleting or Renaming Lists
 
Glad it helped !
Thanks for feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tail Wind" wrote:
Thank you so much Max. That was sooo easy I'm sick! I just couldn't locate
the solution until you helped out.

Thanks again.



All times are GMT +1. The time now is 02:24 PM.

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