jammer6_9
03-03-2008, 05:47 AM
Is it possible to change a certain formula in a target cell by changing only the sheet name. I am trying to do is when I rename the Tabsheet, it will edit my formula which is cell link. I just want to edit the the formula in range a4.
=sheet1!$A$4
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
sheet1!$A$4 = ActiveSheet.Name 'might be change when sheet is renamed.
End Sub
Sorry, wrong subject entered...
=sheet1!$A$4
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
sheet1!$A$4 = ActiveSheet.Name 'might be change when sheet is renamed.
End Sub
Sorry, wrong subject entered...