Worksheet Tab Names.

[Nigel Martin]

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]

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]

Just the job ! Many thanks.