Thank you. I have used the method of looping through the names in the
workbook before, but I wanted to avoid it because I have several
hundred named cells and the main objective of my code is to determine
the name of the cell so I can write a value to that cell from a
separate sheet. For example
I think this does what you want:
Public Sub GetNames()
Dim n As Integer
For n = 1 To ActiveWorkbook.Names.Count
Sheets("Sheet2").Cells(n, 1).Value = ActiveWorkbook.Names(n).Name
Next
End Sub
On Sun, Nov 9, 2008 at 2:04 PM, <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have an exce
