Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Is there a way to write a procedure that will pull all the cell names off a
range of cells and put it into a list? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
There is an ADD-IN called ASAP Utilities that will put all named ranges in a
new workbook, along with many, many other useful tools. http://www.asap-utilities.com/ Mike F "ranswert" wrote in message ... Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Do you want a list of defined names?
-- Don Guillett Microsoft MVP Excel SalesAid Software "ranswert" wrote in message ... Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
yes
"Don Guillett" wrote: Do you want a list of defined names? -- Don Guillett Microsoft MVP Excel SalesAid Software "ranswert" wrote in message ... Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Perhaps I'm missing something but isn't it F3 and paste list
Mike "ranswert" wrote: Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
I was trying to get the defined names for a certain range.
"Mike H" wrote: Perhaps I'm missing something but isn't it F3 and paste list Mike "ranswert" wrote: Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Sub listum()
Dim Nm As Name Set r = Selection namelist = "" For Each Nm In ActiveWorkbook.Names If Intersect(Range(Nm), r) Is Nothing Then Else namelist = namelist & "," & Nm.Name End If Next MsgBox (namelist) End Sub Forgive the leading comma -- Gary''s Student - gsnu200766 "ranswert" wrote: Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
named cells
Thanks I'll give that a try
"Gary''s Student" wrote: Sub listum() Dim Nm As Name Set r = Selection namelist = "" For Each Nm In ActiveWorkbook.Names If Intersect(Range(Nm), r) Is Nothing Then Else namelist = namelist & "," & Nm.Name End If Next MsgBox (namelist) End Sub Forgive the leading comma -- Gary''s Student - gsnu200766 "ranswert" wrote: Is there a way to write a procedure that will pull all the cell names off a range of cells and put it into a list? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named cells | Excel Programming | |||
How many named cells | Excel Programming | |||
Excell named cells or labeled cells question | Excel Programming | |||
Excel named cells or labeled cells question | Excel Programming | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) |