' Macro3 Macro
F09.Range("H7").Select
Selection.Copy
' contenu de la case H7 ActiveCell.FormulaR1C1 = _
'"=DECALER(BdDonnees!$A$1;;;NBVAL(BdDonnees!$A:$A);NBVAL(BdDonnees!$1:$1))"
ActiveWorkbook.Worksheets("Données").Names.Add Name:="tcd", RefersToR1C1:= _
"=OFFSET(BdDonnees!R1C1,,,COUNTA(BdDonnees!C1),COUNTA(BdDonnees!R1))"
ActiveWorkbook.Worksheets("Données").Names("tcd").Comment = ""
End Sub