Sub Imprimer_en_NB()
Range("B5:J39").Select
Selection.Copy
Range("B49").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
With Selection.Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
Range("B49:J83").Select
Selection.FormatConditions.Delete
Selection.PrintPreview
'Selection.PrintOut Copies:=1
Selection.Delete Shift:=xlUp
Range("A1").Select
End Sub