Hi,
I've been searching numerous forums looking for this answer and I can't figure this one out.

I'm trying to get VBA to update a cell on a spreadsheet to read the following formula:

=CONCATENATE("≤",adminLowDaysFlightMax," HRs")
This would give me a result like "≤74 Hrs" in that cell depending on the variable in the listed adminLowDaysFightMax range.

VBA does not recognize the "≤" symbol so I have to use the unicode reference of ChrW(&H2264).

This code works without the symbol I want:
Range("N15") = "=CONCATENATE("">"",adminLowDaysFlightMax,"" HRs"")"
No matter where I put the quotations or & signs in this formula, I cannot get it to accept the "ChrW(&H2264)" in place of the ">".

Please help.

Thank you,
Landon