With ActiveSheet .Range([NbUXParCC2a], [NbUXParCC2a].Offset(0, 1)).Merge End With
Range(Cells(lolo1.Row, lolo1.Column), Cells(lolo1.Row, lolo1.Column + 1)).Select With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlBottom .WrapText = False .Orientation = 0 .AddIndent = False .IndentLevel = 0 .ShrinkToFit = False .ReadingOrder = xlContext .MergeCells = False End With Selection.Merge
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWith ActiveSheet .Range(Cells(.Range("NbUXParCC2a").Row, .Range("NbUXParCC2a").Column), Cells(.Range("NbUXParCC2a").Row, .Range("NbUXParCC2a").Column + 1)).Merge End With____________________
With ActiveSheet .Range("NbUXParCC2a:" & .Range("NbUXParCC2a").Offset(0, 1).AddressLocal).Merge End With