Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ITERATING THROUGH WORKSHEETS ! !
Hi - Two questions:
1. I am looping through worksheets in a workbook. However, I do not want to loop through any sheets that contain the color yellow (i.e, colorindex 6)in any cell. The sheets many and any help would be appreciated. 2. Also, if there are say about 25 sheets in a workbook labeled in order from "SheetA", "SheetB", "SheetC".....though "SheetY", how do I loop through ONLY from say "SheetN" through "SheetY" without using "if sht.name<"..." OR "if sht.name="..." so many times? Thanks Jay *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
iterating through worksheets | Excel Programming | |||
Iterating through a collection (For Each) | Excel Programming | |||
iterating groups? | Excel Programming | |||
iterating checkboxes | Excel Discussion (Misc queries) | |||
Iterating Thru Cells | Excel Programming |