Making cell value the sheet name

[mcmba]

Does anyone remember the code in VB (or elsewhere) that will name a sheet with a cell value??

For example if cell A1 says: "Joe", I want the sheet name to be "Joe". I have seen it done, I just don't know how....any help would be appreciated!! Thanks in advance!

 

[Juan Pablo González]

Try with

Sub SheetName()
ActiveSheet.Name = Range("A1").Text
End Sub

 

[mcmba]

Worked like a champ!!! Thanks!