Change Sheet name based on Cell that contains a formuls

[AdaLake]

Hi- I am using the following code to name my worksheets based on a cell on that same worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(False, False) = "K4" Then Me.Name = Target.Value
End Sub

The issue is that the worksheet name only updates if i click into cell K4 to activate the cell. I think the issue is that K4 is not a hard coded value, but rather a formula. (The formula is a concatenation of a value from another cell on the sheet and a value from a drop down on summary sheet.)

When I change the dropdown, then the value of K4 changes, but the worksheet name does not change. Is there a way to run the code based on a formula change instead of a manual change?

Thanks for your insight.

[JasperD]

This will work. Make sure to dim the variable outside the sub.

Please Login or Register  to view this content.

Please click the * below if this helps