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

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 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
>

Stefi,

You can get the full Unicode list here
http://scripts.sil.org/cms/scripts/p...celUnicodeData

The closest I got to what I think you mean is 9617

Range("E2").Value = ChrW(9617)

Mike


"Stefi" wrote:

> 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 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
> >

Stefi,

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

Mike

"Stefi" wrote:

> Thanks Mike, that it is. I misled myself because I didn't notice that Excel's
> Insert>Symbols dialog displays the Unicode character codes in hexadecimal
> format. (9617=2591H)
>
> Regards,
> Stefi
>
>
> „Mike Hâ€� ezt Ã*rta:
>
> > Stefi,
> >
> > You can get the full Unicode list here
> > http://scripts.sil.org/cms/scripts/p...celUnicodeData
> >
> > The closest I got to what I think you mean is 9617
> >
> > Range("E2").Value = ChrW(9617)
> >
> > Mike
> >
> >
> > "Stefi" wrote:
> >
> > > 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 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
> > > >

Anyway you hit it!
Thanks again!
Stefi


„Mike Hâ€� ezt Ã*rta:

> Stefi,
>
> I hadn't spotted that was the hex equivalent I just ploughed through the
> list. Thanks for the feedback.
>
> Mike
>
> "Stefi" wrote:
>
> > Thanks Mike, that it is. I misled myself because I didn't notice that Excel's
> > Insert>Symbols dialog displays the Unicode character codes in hexadecimal
> > format. (9617=2591H)
> >
> > Regards,
> > Stefi
> >
> >
> > „Mike Hâ€� ezt Ã*rta:
> >
> > > Stefi,
> > >
> > > You can get the full Unicode list here
> > > http://scripts.sil.org/cms/scripts/p...celUnicodeData
> > >
> > > The closest I got to what I think you mean is 9617
> > >
> > > Range("E2").Value = ChrW(9617)
> > >
> > > Mike
> > >
> > >
> > > "Stefi" wrote:
> > >
> > > > 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 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
> > > > >