jacky49
XLDnaute Impliqué
Bonsoir le forum,
J'ai ce code ou je voudrais ajouter le rangement du plus petit au plus grande de la colonne EN7:EN105
merci
jacky
J'ai ce code ou je voudrais ajouter le rangement du plus petit au plus grande de la colonne EN7:EN105
merci
jacky
Code:
Sub PlacementSurLaLigne(ByVal WsName As String)
Application.ScreenUpdating = False
Dim Ws As Worksheet
Dim MaPlage As Range
Set Ws = Worksheets(WsName)
Derlig = Ws.Range("EL" & Ws.Rows.Count).End(xlUp).Row
Set MaPlage = Ws.Range("EI1:FC" & Derlig)
Rows("2:4").Hidden = True
Columns("EM:EM").EntireColumn.Hidden = True
Columns("EO:EZ").EntireColumn.Hidden = True
With Ws.PageSetup
.PrintArea = MaPlage.Address
'.LeftFooter = ""
'.CenterFooter = "&""Times New Roman,italique""&18" & [FC8] & Chr(10) & [FE8] & " " & [FF8] & " , " & [FG8] & " , " & [FH8] & " " & [FI8] & " " & [FJ8]
'.RightFooter = ""
End With
With Ws.PageSetup
.PrintArea = MaPlage.Address
'.LeftHeader = ""
.CenterHeader = "&""Times New Roman,italique""&20" & [EN5] & Chr(10) & [EM2] & " " & [FJ8] & Chr(10) & Chr(10) & [EK3] & Chr(10) & [EI4]
'.RightHeader = ""
End With
Ws.PrintOut Copies:=4, Collate:=True
Application.ScreenUpdating = True
Call insertionImage_EntetePage
End Sub