ActiveSheet.name=Range("A1").value

Does that help?
Paul

--

"des-sa" wrote in message
...
is it possible to force a cell enty as a sheet name, i.e. i have a
worksheet
that i use for quoting for clients. i wrote a macro that automatically
put a
new number on each sheet when it duplicate the master sheet. i would like
that quote number in the worksheet, to be used as the sheet number for
easy
reference