Making cell value the sheet name

mcmba · Feb 19th, 2002, 06:30 AM

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 · Feb 19th, 2002, 06:38 AM

Try with

Code:

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

mcmba · Feb 19th, 2002, 07:08 AM

Worked like a champ!!! Thanks!

Feb 19th, 2002, 06:38 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Try with Code: Sub SheetName() ActiveSheet.Name = Range("A1").Text End Sub __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 06:30 AM	#1
mcmba Board Regular Join Date: Feb 2002 Posts: 59	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!

Feb 19th, 2002, 07:08 AM	#3
mcmba Board Regular Join Date: Feb 2002 Posts: 59	Worked like a champ!!! Thanks!