Can I use a formula to name a worksheet?

		Microsoft Office Forums > Microsoft Excel > Excel
Can I use a formula to name a worksheet?

06-07-2010, 08:47 AM

ConneXionLost ConneXionLost is offline

Windows XP Can I use a formula to name a worksheet?

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,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Headers in Same Worksheet	Tom	Excel	3	05-18-2011 03:22 PM
Seperate Column widths in one worksheet	miller.3276	Excel	2	01-27-2010 02:12 PM
Worksheet copying?	markg2	Excel	4	01-07-2010 10:08 AM
TRANSFER DATA TO NEW WORKSHEET	BOBN	Excel	0	11-08-2007 10:34 PM
click a cell to go to a worksheet	victor	Excel	0	10-27-2006 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:06 AM.