Concatenate with a Unicode Character

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Mike,
I'm glad you pointed out that ChrW would not be recognized in a worksheet. The Char(178) gave me a post script 2. Looking through the hex and non-unicode characters, the ≤ character does not exist. Excel 2013 added a new formula "=UNICODE()" but I'm using 2010 so I was SOL. I did figure out that I could have VBA write the ≤ character by itself somewhere else int he workbook then use a regular reference formula to make it work.

Please Login or Register  to view this content.

VBA would write this formula and it fixed the problem; indirectly, but solved. Thank you for pointing out the differences.

-Landon

I think that either of the last two suggestions would have fixed it. I did use Andy's on it and it worked perfectly. I can push out the patch to my safety officers now. Thanks a lot guys. I am usually saved by this forum before I have to ask for help. Keep up the awesome work.