Posted to microsoft.public.excel.programming

ExcelMonkey[_190_] ExcelMonkey[_190_] is offline

external usenet poster

Posts: 172

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Loop through data for conditions and create a new sheet	Mackay 1979	Excel Programming	3	September 6th 04 11:58 PM
Jump out of Do Loop on sheet change	Paul	Excel Programming	2	May 14th 04 04:21 PM
Loop - for each sheet not working?	Shetty	Excel Programming	6	January 15th 04 02:22 PM
Another loop & sheet question	steve	Excel Programming	4	November 25th 03 02:12 PM
Excluding sheet in loop	david	Excel Programming	2	July 31st 03 03:18 AM

All times are GMT +1. The time now is 03:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us