Bonjour,
Voici un moyen de contourner :
EDIT : correction du code. copié/collé de la mauvaise macro...
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20 Sub formule() Dim cell_devise As String, cell_vdevise As String, cell_devise1 As String, cell_vdevise1 As String Dim valo As Double, valo2 As Double, valo3 As Double, valo4 As Double cell_devise = "F5" cell_vdevise = "F6" cell_devise1 = "G5" cell_vdevise1 = "G6" valo2 = 1000000 valo = 850000 valo3 = Range(cell_devise).Value valo4 = Range(cell_devise1).Value Range(cell_devise).Formula = "" Range(cell_devise1).Formula = "" Range(cell_devise).FormulaLocal = "=" & valo3 + valo2 & "/" & cell_vdevise Range(cell_devise1).FormulaLocal = "=" & valo4 + valo & " / " & cell_vdevise1 End Sub
Partager