Bonjour,
Une idée pour optimiser ce morceau de code ?
Sheets("filtre").Activate
Range("A20:B121").Select
Selection.Copy
Sheets("cmd").Select
Range("BY2").Select
ActiveSheet.Paste
Sheets("cmd").Activate
Columns("BY:BZ").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Columns("BY:BY").Select
Selection.Replace What:="#N/A", Replacement:="La commande n'est pas lier à un", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Columns("BZ:BZ").Select
Selection.Replace What:="#N/A", Replacement:="projet !", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False