PDA

View Full Version : Activesheet Name to Change col_index_number of a vlookup



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...

Bob Phillips
03-03-2008, 06:01 AM
Surely, that already automatically happens when you rename the sheet?