N
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
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