I have several lists of cells in a single column, some of them have non standard characters in them, and I just want to flag each cell like that. There are usually only a couple in each list, but the lists have several thousand rows each.
I need a VBA macro to check for any character that isn’t the standard A-Z, 0-9, or any of these !@#$%^&()-_+=<>,./?:;”‘[{]}|
I jsut need it to check and mark each cell, preferably by changing the color to yellow and then move to the next cell in the column until it hits a blank row.
Most of this I could do, except how to actually check the string for characters, especially since I don’t even know what all the characters will be.
I keep getting weird characters like “” or “£” or “Á” and my database does not like these.