Highlight special (dis-allowed) characters in a worksheet

J

Jack

Looking for a way to clean up data in an Excel worksheet that is to be
imported to a database. Much of the data is text. Only certain characters
can be allowed (essentially those found on the keyboard). Would prefer to
have the dis-allowed characters highlighted in some way (color change, bold,
etc.). I can identify allowable characters by ASCII code. Has anyone seen
or willing to provide an add-in or macro that would suit my needs?

Thanks very much!

Jack
 
D

Dave Peterson

If you come up with the list of characters, you should be able to make this work
ok:

http://groups.google.co.uk/group/mi...nsubject:Excel"&rnum=1&hl=en#ae0174f07151048b

or

http://snipurl.com/hv6b

This line:
myWords = Array("widgets")
is what is highlighted.

You could use:
myWords = Array(chr(1),chr(2),chr(3))

And Chip Pearson's CellView addin may help you find those codes:
http://www.cpearson.com/excel/CellView.htm

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top