For A = 6 To Z 'feuille 2 For B = 3 To Y 'feuill1 If Worksheets("Feuil2").Cells(A, 1).Value = Right(Worksheets("Feuil1").Cells(B, 8).Value, 6) Then D = Worksheets("Feuil1").Cells(B, 8).Value Worksheets("Feuil2").Activate ActiveSheet.Hyperlinks.Add Anchor:=Worksheets("Feuil2").Cells(A, 5), Address:="'Feuil1'" & "!H" & D, SubAddress:="" Range(Cells(6, 5), Cells(Z, 6)).Select Selection.Font.ColorIndex = 0 Selection.HorizontalAlignment = xlCenter Else End If Next B Next A
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim X As Long X = 4 ActiveSheet.Hyperlinks.Add Anchor:=Worksheets("Feuil2").Cells(2, 5), Address:="", SubAddress:= _ "Feuil1!B" & X, TextToDisplay:="Feuil1!B" & X