Thanks for the help, could explain what that coding does for me please?

My WS with the names i want to copy is called M, will this code copy all
names on WS M to all active WS's? changing the first letter of the names to
the name of the active WS's etc?

"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