Ignoring Sheet in For Each Loop
 

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

Ignoring Sheet in For Each Loop
 

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

Ignoring Sheet in For Each Loop
 

ExcelMonkey

You are setting the sh.name to lower case and then comparing it to text
which is proper case, so the Audit Sheet will be audit sheet when tested
against Audit Sheet. If you want to leave LCase then change the test to
"audit sheet".

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"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

Ignoring Sheet in For Each Loop
 

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


.