View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JackGombola[_2_] JackGombola[_2_] is offline
external usenet poster
 
Posts: 11
Default Highlighting leading or trailing spaces

I have church members who submit Excel 2003 spreadsheets to me with name and
address information in columns A thru E (Name, address, city, state, zip).
Some sheets are submitted with either leading or trailing spaces in various
cells.

I would like a macro that would inspect each cell in every column for
leading or trailing spaces and highlight them with a blue background color so
that the users can see the spaces when I return the sheets to them.

Thanks,
Jack