to get the basic code to rename a worksheet.
Then finish it with some code like
and replace the new name of the worksheet in the code by Selection.Value
This assumes that the new name is in cell C2 of worksheet A.
Hope this helps.
I need a macro that will rename a worksheet to the text that is written in a cell on my spreadsheet, help anyone?