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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ITERATING THROUGH WORKSHEETS ! !
here's one way if they're in order
Sub test() Dim i As Long For i = 13 To 25 Worksheets(i).Activate Next End Sub -- Gary "jay dean" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ITERATING THROUGH WORKSHEETS ! !
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ITERATING THROUGH WORKSHEETS ! !
|
Reply |
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 |