View Single Post
 
Old 06-07-2010, 08:47 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Windows XP Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

Formula? No.

VBA? Yes. Use the "Name" property of the "Sheets" object.

In this case, select the cell with the name in it, then run the code:

Code:
Sub RenameSheet()

ActiveSheet.Name = ActiveCell.Value

End Sub
Cheers,
Reply With Quote