I don't understand why anyone would want to use a macro
that switches each entry to something else depending
on what is in each cell. The usual purpose of such a macro
to change case is to make the case for all of the cells
consistent. I would suggest using separate macros
depending on what case you want everyting in the selection
to be. For instance use one macro for capitals wanted such
as zipcode, and use another for proper case such as people's names.

Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

Example data in the following format will not be made consistent,
by the subroutine that does a switcheroo based on current cell content.

David McRitchie
HARVEY QUINCY
BoB Roberts
Jim Roberts
Arlene SANFORD
tony weston

Results of macro -- SwitchCasei
david mcritchie
Harvey Quincy
bob roberts
jim roberts
arlene sanford
TONY WESTON

Results of use of Proper_Case on my webpage
David McRitchie
Harvey Quincy
Bob Roberts
Jim Roberts
Arlene Sanford
Tony Weston

Rather than trying to fix names at proper case for exceptions
there might be a reason to check if the original case is
lower case, or upper case to change it to proper case; otherwise,
leave it alone because you may have done special work like
figuring out that Mackey and MacKey are two different names
and are capitalized differently, and that even within some families
member may even capitalize their lastname differently..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Padgett " wrote ...
Ever thought of just making a couple written macros and applying them to
your own toolbar, or menubar?

The following code will change a cell to UPPER, lower or Proper
depending on how many times you click the Icon you assign it too.