Salut,
pas tres clair la question !
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim ValeurA As integer, ValeurB As integer
Call MaMacro(ValeurA, ValeurB, Target.Address )
End Sub
Sub MaMacro (Byval A As integer, Byval B As Integer, Byval R As String)
End Sub
ou alors
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim ValeurA As integer, ValeurB As integer
Call MaMacro(ValeurA, ValeurB, Target)
End Sub
Sub MaMacro (Byval A As integer, Byval B As Integer, Byref R As Range) 'pour les objets préférer "byref"
Msgbox "La valeur en " & r.address & " = " & r.Value
End Sub
A+