how to sort sheets by name + how to automatically give a cel

[gandalf]

I have two questions. I know already how to make a new sheet with the name I want (inputbox) using a macro. First of all I want to sort all the sheets after making the new sheet.
Secondly I want a specific cell in the new sheet to have the same name as the sheet so the same name as given in the inputbox.

Thanks in advance.

 

[Jim North]

You will find the answer to your first question here:

http://www.cpearson.com/excel/sortws.htm

 

[Jim North]

Your 2nd answer:

Range("A5").Name=Whatever