![]() ![]() Paste the following code there (below Option Explicit): In the "Project - VBAProject" panel, double-click on ThisWorkbook to open the workbook scope. AsciiDict is defined as a public variable in step 3. This is done when the Workbook_Open event is triggered so that the dictionary is only initiated once when you open the spreadsheet instead of every time you call the function. Next, we create a global dictionary in order to map the accented characters to their unaccented equivalents. We'll need this to define a dictionary object in the subsequent steps. In the Microsoft VBA editor, select Tools / References and put a checkmark next to "Microsoft Scripting Runtime". Now You can see the macro "Sample" in the listįor those who need to remove accent marks from ALL Roman characters, including extended ones like those used in Vietnamese, then follow the instructions below.įirst, let's prepare the spreadsheet to do its VBA magic. '- You may have problem with unicode chars that has code > 255 ![]() '- Add more chars to these 2 string as you want You have to call it like this Option Explicit '- Usage: StripAccent Sheet1.Range("A1:C20") Please see the comment in the above code. I have macros enabled and I have a bunch of others I use so I do not understand why it's not showing. The macro name is not appearing in the list to select. I do not see the option to run the macro in my macros list. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |