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