Thankx. I remember you addressing it a previous post but
I missed your point. I get it now.

Thanks


-----Original Message-----
I mentioned to you before that this would not work. You
are shifting the
case of the sh.Name down, but testing against proper
case. Try

If LCase(sh.Name) < "audit results" Then

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ExcelMonkey" wrote
in message
...
I have a loop which looks through each sheet in my
workbook and then looks through cells. I wanted to set
it
up so that it ignores ones specific sheet called"Audit
Results".

For Each sh In .Worksheets
If LCase(sh.Name) < "Audit Results" Then
Code
Next

However it is not working. Can anyone tell me why?

Thanks


.