Hi Lynn,
You say that some of the cells have all caps, it the other cells
are correct you may not want to apply a proper case macro
to those cells. If they are better than you would get with a macro
you might want to include an additional test
If rng.value = ucase(rng.value) then
ooo current replacement line ooo
end if
There is a macro on my page
http://www.mvps.org/dmcritchie/excel/proper.htm
that attempts to take care of names like McRitchie and de Bruin
where you have to code your own exceptions for some names.
You would invoke the macro Proper_case,
but you would need both macros: Proper_case() and proper_case_inner()
The purpose of splitting the macro was to be able to process
a different selection range from within another macro, but usage
would be transparent..