Gaetan12345
New Member
- Joined
- Feb 8, 2018
- Messages
- 9
Good morning,
i'm writing a simple formula that substract 2 values if a cell is not blank & Excel keeps-on guiving me errors...this seems simple, but i'm not sure where the error is located?
Dim FormuleDonnee As String
FormuleDonnee = "=if($G21<>"";$J21-$G21;"")"
Range("o21").formula = FormuleDonnee
Range("o21").AutoFill Destination:=Range("o21
400")
When i use MSGBOX to find out what is the result of this formula, it seems to take away one of the "...on other examples, they say to write 4 ". Still, the error comes back.
Thank's for any help
i'm writing a simple formula that substract 2 values if a cell is not blank & Excel keeps-on guiving me errors...this seems simple, but i'm not sure where the error is located?
Dim FormuleDonnee As String
FormuleDonnee = "=if($G21<>"";$J21-$G21;"")"
Range("o21").formula = FormuleDonnee
Range("o21").AutoFill Destination:=Range("o21

When i use MSGBOX to find out what is the result of this formula, it seems to take away one of the "...on other examples, they say to write 4 ". Still, the error comes back.
Thank's for any help