Thread
: [Solved]
Can I use a formula to name a worksheet?
View Single Post
06-07-2010, 08:47 AM
ConneXionLost
Windows XP
Office 2003
Simulacrum
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
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,
ConneXionLost
View Public Profile
Find all posts by ConneXionLost