| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Do I list all range names in a worksheet
I have a spreadsheet with over 1,000 range names. 90% are not valid anymore
I woul like to list all the range names thes be able to have the vba code go through this list and delet all the ones that I tag as non needed thanks -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I list all range names in a worksheet
I found this in VBA help files.
Sub nms() Set nms = ActiveWorkbook.Names Set wks = Worksheets(1) For r = 1 To nms.Count wks.Cells(r, 2).Value = nms(r).Name wks.Cells(r, 3).Value = nms(r).RefersToRange.Address Next End Sub "QuietMan" wrote: I have a spreadsheet with over 1,000 range names. 90% are not valid anymore I woul like to list all the range names thes be able to have the vba code go through this list and delet all the ones that I tag as non needed thanks -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I list all range names in a worksheet
Get the (free) Name Manager:
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp at jkp's Application Development Service -- Regards, Tom Ogilvy "QuietMan" wrote: I have a spreadsheet with over 1,000 range names. 90% are not valid anymore I woul like to list all the range names thes be able to have the vba code go through this list and delet all the ones that I tag as non needed thanks -- Helping Is always a good thing |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Do I list all range names in a worksheet
Thanks, good enough to get me started
-- Helping Is always a good thing "JLGWhiz" wrote: I found this in VBA help files. Sub nms() Set nms = ActiveWorkbook.Names Set wks = Worksheets(1) For r = 1 To nms.Count wks.Cells(r, 2).Value = nms(r).Name wks.Cells(r, 3).Value = nms(r).RefersToRange.Address Next End Sub "QuietMan" wrote: I have a spreadsheet with over 1,000 range names. 90% are not valid anymore I woul like to list all the range names thes be able to have the vba code go through this list and delet all the ones that I tag as non needed thanks -- Helping Is always a good thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
| Created list of worksheet names but need list to be hyperlinked to | Excel Programming | |||
| macro to take worksheet names and create dynamic list/range | Excel Programming | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| copy range on every worksheet (diff names) to a master worksheet (to be created) | Excel Programming | |||
Linear Mode
