i work with an excel file that has cells with text primarily in English, however some of them are in non-ASCII characters. When i try to save as CSV (comma delimited), these characters appear as question marks in the CSV file.
So, i'm looking for a macro that checks each character in all cells of the active worksheet; if the cell contains a non-ASCII or a newline character, it changes the fill color of the cell. In the end a message mentions the total number of the highlighted cells.
This is posted over MrExcel too, but still no full working solution. The macro by Wolf so far is the following (with dark red is my comment) and works only if the non-ASCII character is the first letter in the cell:
Please Login or Register to view this content.
Bookmarks