ExcelBanter - block characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - block characters (https://www.excelbanter.com/excel-programming/418694-block-characters.html)

Stefi

block characters

Hi All,

I'd like to insert block characters, e.g. light shade (Unicode: 2591) in
cells. I can do it manually via InsertSymbol, but when I tried
Range("E2").Value = ChrW(2591)
I got an invisible character.

How can I display –‘ in the cell?

Thanks,
Stefi

Stefi

block characters

Sorry, that was another try,
Range("E2").Value = ChrW(2591)
gave à¨Ÿ
Stefi

€žStefi€ ezt Ã*rta:

Hi All,

I'd like to insert block characters, e.g. light shade (Unicode: 2591) in
cells. I can do it manually via InsertSymbol, but when I tried
Range("E2").Value = ChrW(2591)
I got an invisible character.

How can I display –‘ in the cell?

Thanks,
Stefi

All times are GMT +1. The time now is 06:32 PM.