Sub Test()
[A1] = 123
[A1].Copy
Clipboard
Application.CutCopyMode = 0
End Sub
Sub Clipboard()
Dim ac As Range, c As Range, v As Variant
Application.ScreenUpdating = False
Set ac = ActiveCell
Set c = Cells.Find("", , xlValues) 'cellule vide
c.Select
On Error Resume Next
Paste
v = c
c = ""
ac.Select
If IsNumeric(CStr(v)) Then Application.ScreenUpdating = True: MsgBox "Valeur numérique : " & v, , "Clipboard"
End Sub