LinkBack URL
About LinkBacks
ChrW is a VBA funtion, but not a worksheet function.
You could use the non-unicode character CHAR(178)
ChrW is a VBA funtion, but not a worksheet function.
You could use the non-unicode character CHAR(178)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
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.
VBA would write this formula and it fixed the problem; indirectly, but solved. Thank you for pointing out the differences.
=CONCATENATE(DEV!$A$11,adminLowDaysFlightMax," HRs")
-Landon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks