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
|