Worksheet Tab Names.

Nigel Martin · Apr 4th, 2002, 01:36 AM

I have a spreadsheet which generates a reference number in a cell. Is it possible that once this number has been generated the worksheet tab can be changed automatically to reflect the value in the cell ?

jrnyman · Apr 4th, 2002, 02:44 AM

Have you tried something like this:

Sub TabName()
ActiveSheet.Name = Range("A1").Value 'A1 is the cell with the reference number
End Sub

Nigel Martin · Apr 4th, 2002, 05:08 AM

Just the job ! Many thanks.

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

Apr 4th, 2002, 01:36 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	I have a spreadsheet which generates a reference number in a cell. Is it possible that once this number has been generated the worksheet tab can be changed automatically to reflect the value in the cell ?

Apr 4th, 2002, 02:44 AM	#2
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	Have you tried something like this: Sub TabName() ActiveSheet.Name = Range("A1").Value 'A1 is the cell with the reference number End Sub

Apr 4th, 2002, 05:08 AM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Just the job ! Many thanks.