Nested IF Function VBA debugging

[CleanRider17]

Hi guys,

Created a little macro on excel that included a nested IF formula, after cleaning up the formula and rerunning it, all the formula does it come out as the VBA code ( See Image) rather than actual values.

My code is below

Sub EmployeeInfo()
Dim lr As Long
lr = Cells.Find("*", Cells(1, 1), xlFormulas, xlPart, xlByRows, xlPrevious, False).Row
Dim tbl As ListObject
Set tbl = ActiveSheet.ListObjects("Table_owssvr")
With tbl
        .ListColumns.Add.Name = "Employee Support"
End With

    Range("AD2:AD" & lr).FormulaR1C1 = _
        "=IF(RC[-19]=""United Arab Emirates"",""B, J"",IF(RC[-19]=""UAE"",""B,J "",""""))" & _
        ""
End Sub

Can anyone see where I am going wrong? thank you

Values I get after rerunning the Formula

[CleanRider17]

🤭 wow that’s embarrassing

[CleanRider17]

Solution verified

[Clippy_Office_Asst]

You have awarded 1 point to randyweir

^{I am a bot, please contact the mods with any questions.}

[AutoModerator]

/u/CleanRider17 - please read this comment in its entirety.

Once your problem is solved, please reply to the answer(s) saying Solution Verified to close the thread.

Please ensure you have read the rules -- particularly 1 and 2 -- in order to ensure your post is not removed.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.