Sub test()
ReDim tabnom(2, 0)
For Each celnommée In Application.Names
tabnom(1, UBound(tabnom, 2)) = celnommée.RefersTo
tabnom(2, UBound(tabnom, 2)) = celnommée.Name
ReDim Preserve tabnom(2, UBound(tabnom, 2) + 1)
Next
For n = LBound(tabnom, 2) To UBound(tabnom, 2) - 1
MsgBox (tabnom(2, n) & " " & tabnom(1, n))
Next
End Sub