Microsoft Office Forums - View Single Post - [Solved] Can I use a formula to name a worksheet?

Thread: [Solved] Can I use a formula to name a worksheet?

View Single Post

Old

06-07-2010, 08:47 AM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

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