sheet names

  • Thread starter Thread starter Lorraine
  • Start date Start date
L

Lorraine

I would like to name a sheet reference back to a cell.
Example: If I type a client's name in cell B4, I want a
new sheet created with the name of that entry.
 
right click sheet tab>view code>copy/paste this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address <> "$B$4" Then Exit Sub
Sheets.Add.Name = Target
End Sub
 
Back
Top