Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop through data for conditions and create a new sheet | Excel Programming | |||
Jump out of Do Loop on sheet change | Excel Programming | |||
Loop - for each sheet not working? | Excel Programming | |||
Another loop & sheet question | Excel Programming | |||
Excluding sheet in loop | Excel Programming |