I'm trying to programmatically (VBA) insert the Triangular Flag symbol, Character code: 1F6A9, converted to Decimal is 128681. It can be found in Symbols > Font: Segoe UI Symbol > Subset: Extended Characters - Plane 1 > about 24 rows from the bottom.
I've tried variations of Chr(), ChrW(), AscW; with and without "&H" and also tried converting to binary
[A1] = ChrW(128681)
[A1] = ChrW(&H1F6A9)
[A1] = AscW(128681)
[A1] = AscW(&H1F6A9)
[A1] = Asc(1.1111011010101E+16)
None seem to give me a flag. Sometimes they they result in "49" though.