Hi
Here's
VB Code which gets you the name list, reference and values
Sub NamesLister()
For i = 1 To ActiveWorkbook.Names.Count
Sheets("Sheet1").Activate
Cells(i, 1).Value = ActiveWorkbook.Names(i).Name
Cells(i, 2).Value = ActiveWorkbook.Names(i).RefersToRange.Address
Cells(i, 3).Value = ActiveWorkbook.Names(i).RefersToRange.Value
Next
End Sub
"Skinman" wrote:
Hi all,
Using excell 2007 on Vista
Would like to print a list of defined names and associated data (value,
refers to, comments) from a worksheet
Have searched the web but come up empty. Closest was
name manager but I can't find a version for excel 2007
When the define name dialog window is open print options don't
seem to me to be accessible
Skinman