Bonjour
Bonjour à tous
Une variante.
Option Explicit
Dim tablo, tabloR()
Dim i&, k&
Sub Convertir()
tablo = Range("B3:C" & Range("B" & Rows.Count).End(xlUp).Row)
k = 0
For i = 2 To UBound(tablo, 1)
If tablo(i, 1) <> "" Then
ReDim Preserve tabloR(1 To 2, 1 To k + 1)
tabloR(1, k + 1) = tablo(i, 1)
tabloR(2, k + 1) = Replace(tablo(i, 2), ".", ",") * 1
k = k + 1
End If
Next i
Range("B3:C3").Copy Range("E3")
Range("E3").CurrentRegion.Offset(1, 0).Clear
Range("E4").Resize(UBound(tabloR, 2), 2) = Application.Transpose(tabloR)
Range("E4").Resize(UBound(tabloR, 2), 1).BorderAround Weight:=xlThin
Range("F4").Resize(UBound(tabloR, 2), 1).BorderAround Weight:=xlThin
Range("E4").Resize(UBound(tabloR, 2), 2).Sort key1:=Range("F4"), order1:=xlAscending, Header:=xlNo
Range("E4").Resize(UBound(tabloR, 2), 2).Interior.Color = RGB(204, 255, 255)
Range("E4").Resize(UBound(tabloR, 2), 2).HorizontalAlignment = xlCenter
End Sub
Bye !