VBA Syntax error: need another set of eyes

[Ody]

Hello all,

I can't find the error in my formula, it's driving me a little crazy.

.Range("q" & lMaxRows + 1).Formula = "=if(iserror(concatenate(text('" & LastSheet & "'!BO49/ '" & LastSheet & "'!BJ49,""0%"") & char(10) & char(10) & '" & LastSheet & "'!BO51),"""",concatenate(text('" & LastSheet & "'!BO49/ '" & LastSheet & "'!BJ49,""0%"") & char(10) & char(10) & '" & LastSheet & "'!BO51)"

Any help is appreciated. Thanks!

 

[xenou]

Put this in a cell. That will help you to see why it doesn't work.

=if(iserror(concatenate(text(''!BO49/ ''!BJ49,"0%") & char(10) & char(10) & ''!BO51),"",concatenate(text(''!BO49/ ''!BJ49,"0%") & char(10) & char(10) & ''!BO51)

I would suggest you write the formula from a cell and put it in your vba when it's correct, rather than trying to write it in VBA.

 

[Ody]

Thanks for the advice. Found the issue.