Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,646
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,646
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Leading Characters If String Is Only 7 Characters Paperback Writer Excel Discussion (Misc queries) 2 April 21st 09 09:07 PM
how to highlight changes in my data from one block of cells toanother block of cells? LunaMoon Excel Programming 1 July 28th 08 04:26 PM
Macro to test characters with block of cells and change font Carolyn Excel Programming 4 September 8th 06 10:02 PM
if/then block within another if/then block needs a loop Janis Excel Programming 1 September 8th 06 10:01 PM
In Excel find characters when multiple characters exist w/i a cel teacher-deburg Excel Worksheet Functions 1 December 5th 05 10:22 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"