block characters

S

Stefi

Hi All,

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

How can I display â–‘ in the cell?

Thanks,
Stefi
 
S

Stefi

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

„Stefi†ezt írta:
 
M

Mike H

Stefi,

I hadn't spotted that was the hex equivalent I just ploughed through the
list. Thanks for the feedback.

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert a symbol using VBA 6
Unicode Problem 3
No characters data in Hyperlink cell 3
Symbol "font" doesn't act like other fonts 1
Column Cell character number checking 4
cell-range relationship & non-standard symbol recognition 3
Symbol "font" - not Unicode compliant, how to Search/Replace? 2
Displaying the infinity symbol in an excel spreadsheet 10

Top