Can't see where I got it wrong...

[finaljustice]

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.

Range("$U$" & linha).Formula = "=Iferror(If($B$" & linha & " ="""",$S$" & linha & "-$C$" & linha & ",$S$" & linha & "-$B$" & linha & "*6,"""")"

where the variable:
linha = 27

This code works:

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

 

[pgc01]

Hi

I haven't tested, but looking at the formula aren't you missing a closing parenthesis after the 6, to close the If()?

 

[finaljustice]

Hi

I haven't tested, but looking at the formula aren't you missing a closing parenthesis after the 6, to close the If()?

Hi thanks for answering but you are right, I was tiered as hell and the attention span goes coocoo!!!
thanks m8
yours
fj

 

[JLGWhiz]

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.

Range("$U$" & linha).Formula = "=Iferror(If($B$" & linha & " ="""",$S$" & linha & "-$C$" & linha & ",$S$" & linha & "-$B$" & linha & "*6,"""")"

where the variable:
linha = 27

This code works:

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

This includes the closing parenthses for the If statement

Code:
Range("$U$" & linha).Formula = "=Iferror(If($B$" & linha & " = """", $S$" & linha & "-$C$" & linha & ",$S$" & linha & "-$B$" & linha & "*6),"""")"
Code: