+ Reply to Thread
Results 1 to 3 of 3

character Å (probably Chr(134)) doesn't work

  1. #1
    Registered User
    Join Date
    11-11-2004
    Location
    Czech Republic
    MS-Off Ver
    Excel 2016 for Windows 10
    Posts
    22

    character Å (probably Chr(134)) doesn't work

    Hello,

    I would need to add character Å into text. It's summary character for barcode 128. It should be Chr(143), but this is in range, which doesn't work in VBA. Any tip how to do it and don't have to write it into cell in worksheet?

    thank You in advance

    Martin
    Last edited by MartyZ; 05-05-2021 at 06:11 AM.

  2. #2
    Registered User
    Join Date
    11-11-2004
    Location
    Czech Republic
    MS-Off Ver
    Excel 2016 for Windows 10
    Posts
    22

    Re: character Å (probably Chr(134)) doesn't work

    It works with ChrW(&H00C5).

  3. #3
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    365 32bit Win
    Posts
    1,909

    Re: character Å (probably Chr(134)) doesn't work

    Chr(197) also produces that character for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If statement - unable to work out why it doesn't work
    By vba_newbie83 in forum Excel General
    Replies: 3
    Last Post: 11-25-2019, 09:26 AM
  2. [SOLVED] Adding a character to column if column doesn't already end in same character
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-09-2018, 10:32 PM
  3. [SOLVED] if a string doesn't contain a character insert that character.
    By LenaK in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-31-2015, 12:54 PM
  4. [SOLVED] Concat_Range macro doesn't like 255+ character limit
    By jontherev in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2014, 03:35 AM
  5. [SOLVED] F4 doesn't work only in excel, how to make it work again?
    By Dave H in forum Excel General
    Replies: 1
    Last Post: 02-26-2014, 11:22 AM
  6. [SOLVED] Macro work in personal workbook, doesn't work in other workbooks
    By Centexcel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2013, 11:47 AM
  7. [SOLVED] Macro Doesn't Work Through Button, Does Work Through Developer ->Macros Option
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-27-2013, 11:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1