Naming a worksheet based on cell data

Hi

You cant use the caracter "/" in the name of your sheet.
You have tu use a diffrent caracter

"-" can be used instead of "/"

Still need to solve the main problem though.

Thanks,
-Chris

Hi,

Add the following code to each worksheets Worksheet Change Event procedure.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.AddressLocal(False, False) = "B2" Then
ActiveSheet.Name = "Week of " & Format(Target.Value, "dd-mmm-yy")
End If

End Sub

Hope this helps,
Leith Ross

Much thanks. It works great!

-Chris