+ Reply to Thread
Results 1 to 4 of 4

Special Character

  1. #1
    Forum Contributor
    Join Date
    10-09-2012
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Special Character

    Hi everyone,
    below is part of my code that doesn't seem to be recognizing Ω in VBA, I have tried the below segment of code refereeing to the Unicode but still having problems. HELP

    Please Login or Register  to view this content.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Special Character

    This is the Omega Chrw

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,357

    Re: Special Character

    Or this.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Forum Contributor
    Join Date
    10-09-2012
    Location
    Adelaide, South Australia
    MS-Off Ver
    Excel 2010
    Posts
    135

    Re: Special Character

    Thanks guys, I got around it by including the value from a cell. I Tried ChrW(937) and it didn't seem to work.

+ 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. Replace special character
    By winmaxservices in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-18-2016, 12:48 AM
  2. Need to highlight special character and the cells contains special character
    By dhilipan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2013, 01:36 AM
  3. [SOLVED] Delete row that contains special character *
    By canada123 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-17-2013, 12:25 PM
  4. Special character in comments
    By MikeR613 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2010, 03:21 AM
  5. Special Character
    By Henry in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 08:10 AM
  6. [SOLVED] Allow only one special character i a cell
    By Zadig Galbaras in forum Excel General
    Replies: 3
    Last Post: 02-03-2006, 09:40 AM
  7. move a special character
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2005, 07:05 PM

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