1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Sub renomer_tlssyp()
' renomer_tlssyp Macro
Windows("Classeur1").Activate
Sheets("Montants facturés par carte").Select
Columns("E:E").Select
selection.Find(What:="TLSSYP", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(rowOffset:=0, columnOffset:=-4).Activate
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[4],Codex!C:C[2],2,FALSE)"
selection.Copy
ActiveCell.Offset(rowOffset:=0, columnOffset:=4).Activate
selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(rowOffset:=0, columnOffset:=-4).Activate
Application.CutCopyMode = False
selection.ClearContents
End Sub |
Partager