| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to do for each worksheet in workbook exept one sheet??
this is part of my source code
For Each sh In ActiveWorkbook.Worksheets sh.Range("b7").AutoFilter field:=1, Criteria1:="<", visibledropdown:=False Next I want to use this but worksheet("overview") may not participate in the" for each" procedure something with exit for? thankx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do for each worksheet in workbook exept one sheet??
Matthias,
This is something like what I use at the moment Dim wks As Worksheet Set ActSheet = ActiveSheet overview.activate For Each wks In ActSheet.Parent.Worksheets If wks.Name < ActSheet.Name Then 'do nothing Else For Each sh In ActiveWorkbook.Worksheets sh.Range("b7").AutoFilter field:=1, Criteria1:="<", visibledropdown:=False Next HTH Duncan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do for each worksheet in workbook exept one sheet??
ooops,
miss out your for each, i just copied your code and pasted it in. I think there is a better way though......................... |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do for each worksheet in workbook exept one sheet??
For Each sh In ActiveWorkbook.Worksheets
If sh.Name < "overview" Then sh.Range("b7").AutoFilter field:=1, _ Criteria1:="<", _ visibledropdown:=False End If Next -- HTH Bob Phillips (remove nothere from email address if mailing direct) "matthias" wrote in message oups.com... this is part of my source code For Each sh In ActiveWorkbook.Worksheets sh.Range("b7").AutoFilter field:=1, Criteria1:="<", visibledropdown:=False Next I want to use this but worksheet("overview") may not participate in the" for each" procedure something with exit for? thankx |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to do for each worksheet in workbook exept one sheet??
perfect guys!!! thanks
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicating Worksheet to 20 sheet workbook | Excel Discussion (Misc queries) | |||
| copy data from one worksheet to identical sheet in different workbook | Excel Discussion (Misc queries) | |||
| EXCEL: Find data in worksheet and create a new sheet in same workbook | Excel Programming | |||
| Excel2000: Copy all exept data | Excel Programming | |||
| My workbook doesn't works on no other PC exept mine.... | Excel Programming | |||
Hybrid Mode
