Hi
in VBA with
with activesheet
..name=.range("A1").value
end with

"Phil12345678910" wrote:

Hi,

Does anyone know if its possible to name a tab from a cell reference in a
worksheet.

I am developing a Excel spreadsheet to hold details of projects, each
project has a separate tab. I would like the tab to automatically rename
itself from the cell that the project number is typed into.....

Any help would be much appreciated.