VBA Adding @ to variant Formulas

[seniorjerry]

Hey I'm writing a VBA function to generate a couple reports in a consistent printable format. Everything is working fine thus far except that variable functions I am inputting into a cell are adding an @ symbol and breaking the function making it have to be manually fixed. Is their a way to make it stop including these @ symbols?

    For L2 = 2 To 12
        CellChar = Switch(L2 = 2, "B", L2 = 3, "C", L2 = 4, "D", L2 = 5, "E", L2 = 6, "F", L2 = 7, "G", L2 = 8, "H", L2 = 9, "I", L2 = 10, "J", L2 = 11, "K", L2 = 12, "L")
        CellChar2 = Switch(L2 = 2, "C", L2 = 3, "D", L2 = 4, "E", L2 = 5, "F", L2 = 6, "G", L2 = 7, "H", L2 = 8, "I", L2 = 9, "J", L2 = 10, "K", L2 = 11, "L", L2 = 12, "M")
        Sheets("VLF").Cells(XLoc + 3, L2 + 1) = "=COUNTIFS(Rent_Roll[UnitType],$" & CellChar & XLoc + 3 & "#,Rent_Roll[LeaseTo],"" >= ""&" & CellChar2 & "$" & XLoc + 1 & ",Rent_Roll[LeaseTo],"" <= ""&" & CellChar2 & "$" & XLoc + 2 & ")"
    Next L2

I cut out the part of the code that matters and put it here. This keeps resulting in

=@SORT(UNIQUE(Rent_Roll[UnitType]))

instead of

=SORT(UNIQUE(Rent_Roll[UnitType]))

 

[seniorjerry]

Just realized I copied the wrong code snippet meant to paste this formula

Sheets("VLF").Cells(XLoc + 3, 1).Formula = "=SORT(UNIQUE(Rent_Roll[UnitType]))"

 

[seniorjerry]

Just figured it out need to use .Formula2

 

[seniorjerry]

Alright New problem found now that original code snippet is out putting an @ before the first cell location instead of before the countifs and Im not sure how to fix this one.