Sub FormatNombre(sSheetName As String, sColumns As String, sep As String)
Dim sh As Worksheet
Dim derligne, dercolonne
Dim sTabCols() As String
Set sh = ThisWorkbook.Sheets(sSheetName)
sTabCols = Split(sColumns, ",")
derligne = sh.Cells(sh.Rows.Count, 1).End(xlUp).Row
dercolonne = sh.Cells(1, sh.Columns.Count).End(xlToLeft).Column
For i = LBound(sTabCols) To UBound(sTabCols)
'sh.Range("2:AN" & derligne).NumberFormat = "$#,##0"
With sh.Range("B" & derligne + 1)
.Value = 1
.Copy
End With
sh.Range(sTabCols(i) & "2:" & sTabCols(i) & derligne).PasteSpecial Paste:=xlPasteAll, Operation:=xlMultiply, SkipBlanks:=False, Transpose:=False
Next
End Sub
Sub TestFormatNombre()
Call FormatNombre("Sheet1", "B,C,E,", ",")
End Sub