finaljustice
Board Regular
- Joined
- Oct 6, 2010
- Messages
- 175
Hi, I have written a coda that would put formulas inside cells for the users, now I have a simple formula that gives me error and I can't pinpoint where I got it wrong.
where the variable:
linha = 27
This code works:
I honestly can't see where I have made a mistake.
Thanks for the help anyone.
FJ
Code:
Range("$U$" & linha).Formula = "=Iferror(If($B$" & linha & " ="""",$S$" & linha & "-$C$" & linha & ",$S$" & linha & "-$B$" & linha & "*6,"""")"
linha = 27
This code works:
Code:
Range("$M$" & linha).Formula = "=Iferror((VLookup(" & varlookup & ", " & ws & "!$D$6:$AR$" & blimit & ", 7, False)*$K$" & linha & "),"""")"
I honestly can't see where I have made a mistake.
Thanks for the help anyone.
FJ