Create name

[Naz]

Hi all

I'm creating a document with a table of contents hyperlinked to named cells,
and on each workbooks i want to create a name based on the cell contents by
clicking a button but can't figure out the macro, i tried recording one and
changing the value but that didn't work.

I want to click a cell, press a button an a new name is created based on
that cells contents, except if the cell has spaces then the spaces are
converted to underscore _

Can anyone help?

_______________________
Naz,
London

 

[Patrick Molloy]

selection.name = replace(selection.value," ","_")