Sub Test()
Dim Deps As Range, dep As Range
Set Deps = Range("A2").Dependents
For Each dep In Deps
Debug.Print Deps.Address
Next
End Sub
Sub Test()
Dim Deps As Range, dep As Range
Set Deps = Range("A2").Dependents
For Each dep In Deps
Debug.Print Deps.Address
Next
End Sub
Sub MembreFormule()
T = Range([G4])
Range([G4]).Interior.Color = xlNone
Chaine = [G3]
For L = 1 To UBound(T, 1)
For C = 1 To UBound(T, 2)
Formule = Cells(L, C).Formula
If Formule <> "" Then
If InStr(1, Formule, "A1") > 0 Then
Cells(L, C).Interior.Color = RGB(255, 255, 0)
End If
End If
Next C
Next L
End Sub
Sub EffCol()
Range([G4]).Interior.Color = xlNone
End Sub