Sheet name from cell data

[cmunnelly]

Is it possible name a sheet directly from the data that is in a cell. I have a macro that produces a new sheet and an input box. The user inputs the new project name in the box and it is then transferred to cell A1. I want the sheetname to reflect the data the user has input in the box or in cell A1. Is this possible?

thanks in advance

 

[Stretchwickster]

Yep just do something like this, replace "InfoSheet" with the name of the sheet which has the value in A1:

Sheets.Add
ActiveSheet.Name = Worksheets("InfoSheet").Range("A1").Value

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)