1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
Sub main()
Cells.Clear
Call CreerUneValeurDeTypeDate
Call EcrireAvecValue
Call EcrireAvecFormulaLocal
InsererLignes
Call CreerUneValeurDeTypeTexte
Call EcrireAvecValue
Call EcrireAvecFormulaLocal
Columns("A:D").Columns.AutoFit
End Sub
Sub EcrireAvecValue()
lig = 1
Set r = Cells(lig, 1)
t = r.Value
Set r = Cells(lig + 1, 2)
r.NumberFormat = "@"
r.Value = t
Set r = Cells(lig + 1, 3)
r.NumberFormat = "m/d/yyyy"
r.Value = t
Set r = Cells(lig + 1, 4)
r.NumberFormat = ""
r.Value = t
End Sub
Sub EcrireAvecFormulaLocal()
lig = 1
Set r = Cells(lig, 1)
t = r.Value
Set r = Cells(lig + 5, 2)
r.NumberFormat = "@"
r.FormulaLocal = t
Set r = Cells(lig + 5, 3)
r.NumberFormat = "m/d/yyyy"
r.FormulaLocal = t
Set r = Cells(lig + 5, 4)
r.NumberFormat = ""
r.FormulaLocal = t
End Sub
Sub CreerUneValeurDeTypeTexte()
lig = 1
Cells(lig, 1).NumberFormat = "@"
Cells(lig, 1).Value = "APR6198" 'ceci est une date de type String
Call Infos
End Sub
Sub CreerUneValeurDeTypeDate()
Cells(1, 1).NumberFormat = ""
Cells(1, 1) = CDate("1/04/6198") 'ceci est une date de type Date
Infos
End Sub
Sub Infos()
Range("$A$2") = "cell.Value = "
Range("$A$4") = "cell.Numberformat = "
Range("$A$6") = "cell.FormulaLocal = "
Range("$b$4") = "@"
Range("$c$4") = "m/d/yyyy"
Range("$d$4") = "General"
End Sub
Sub InsererLignes()
Rows("1:8").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
End Sub |
Partager