Dim rng As Range, M As Integer
With Worksheets("récapitulatif")
M = .Range("G10").End(xlUp).Row
Set rng = .Range("G1099:G" & M)
rng.Name = "ColG"
Set rng = .Range("I1099:I" & M)
rng.Name = "ColI"
Set rng = .Range("H1099:H" & M)
rng.Name = "ColH"
Set rng = .Range("BH1099:BH" & M)
rng.Name = "ColBH"