Set plage_Y = Worksheets("c-" & choix1).Range("G" & lig & ":G" & derl)
plage_Y.Copy
Range("C2:C" & derl - lig + 2).Formula = 2 'on colle le multiplicateur
Range("C2").PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply ' collage special multiplier