They will not be duplicates I will edit the first letter of them to be the
same as the WS they are for.

Steve

"Tom Ogilvy" wrote in message
...
If you have defined the names at the workbook level, then they can not
refer
to other sheets. You can have duplicate names if you make them worksheet
level

Dim nm as Name
for each nm in ActiveWorkbook
cells(rw,1).Value = nm.name
cells(rw,2).Value = nm.RefersTo
Next

--
Regards,
Tom Ogilvy

"Steven" wrote in message
...
I have defined some names on one of my WS's and need to make the same
names
on some other sheets, how can I view my WB's names so that I can quickly
copy the names over to other WS's? everything in the definitions will be
the
same bar the first letter.

Many thanks,

Steve