Yes, it does. Thanks for the tweaks, Roger!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Roger Govier" wrote:
Hi Max
In case Bob hasn't noticed your request, you can achieve what you want
by forcing the test to be Uppercase on both sides.
in two places within Bob's code.
If UCase(Cells(i, "A").Value) = UCase(Cells(i + 1, "A").Value) Then
and
Do While UCase(Cells(i + j, "A").Value) = UCase(Cells(i, "A").Value)
Bob may well have a better solution , but this will achieve what you
ask.
--
Regards
Roger Govier