Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does this help?
Sub listnamesandrefersto() For Each n In ThisWorkbook.Names lr = Cells(Rows.Count, "a").End(xlUp).Row + 1 Cells(lr, 1) = n.Name Cells(lr, 2) = Right(n.RefersTo, Len(n.RefersTo) - 1) Next End Sub -- Don Guillett SalesAid Software "paul johnson" wrote in message ... I have a spreadsheet using 100 plus named ranges. Is there a quick way to document all these ranges? Many Thanks Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Named Ranges | Excel Programming | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
named ranges - changing ranges with month selected | Excel Programming | |||
Named ranges | Excel Programming | |||
Named ranges | Excel Programming |