Sub NumBord()
Dim Plage As Range, Cell As Range
Dim FirstAddress As String
Dim Response As Double
Set Plage = Range('N:N')
Response = Application.InputBox('Entrez le Nombre en Remplacement', 'Enter Number Only', Type:=1)
Plage.Replace What:='1', Replacement:=Response, LookAt:=xlPart, SearchOrder:=xlByRows
End Sub