1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Sub aujourdhui()
Range("A2").Select
ActiveCell.FormulaR1C1 = "=TODAY()-2"
Range("A3").Select
ActiveCell.FormulaR1C1 = "=TODAY()-1"
Range("A4").Select
ActiveCell.FormulaR1C1 = "=TODAY()"
Range("A5").Select
ActiveCell.FormulaR1C1 = "=TODAY()+1"
Range("A6").Select
ActiveCell.FormulaR1C1 = "=TODAY()+2"
Range("B2").Select
ActiveCell.FormulaR1C1 = _
"=LEFT(TEXT(RC[-1],""jj mm aa""),2)&"" ""&CHOOSE(MONTH(RC[-1]),""A"",""B"",""C"",""D"",""E"",""F"",""G"",""H"",""I"",""J"",""K"",""L"")&"" ""&RIGHT(TEXT(RC[-1],""jj mm aa""),2)"
Selection.AutoFill Destination:=Range("B2:B6"), Type:=xlFillDefault
Range("B2:B6").Select
End Sub |
Partager