Concat Sub or Function no defined

[manthony]

Hi, I am trying to get this if statement with a concat formula to work, but I keep getting the message "Sub or Function not defied." The worksheet where I am trying to get this formula to run on is titled "Report." Thank you in advance for the help.

Below is the code




If Range("L4") = 0 Then

Sheets("Report").Range("A4").Formula = Concat(Worksheets("Parameters").Range("B10") & " has no time reported in " & Worksheets("Parameters").Range("B12"))

ElseIf Range("L4") <> 0 Then
Range("A3").Value = ""
End If

 

[AkaTrouble]

try without the word concat the & symbol is seen as concatenate symbol

 

[snjpverma]

Does the below work

Sub trial()
If range("L4") = 0 Then
Sheets("Report").range("A4").Value = Worksheets("Parameters").range("B10").Value & " has no time reported in " & Worksheets("Parameters").range("B12").Value
ElseIf range("L4") <> 0 Then
range("A3").Value = ""
End If
End Sub

 

[manthony]

That works perfectly. Thank you

 

[snjpverma]

Glad to see it helped you.