| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cycle through non-hidden pages only
Thanks to all. Code works great
Steve "Earl Kiosterud" wrote: Steve, Try this: Sub CycleSheets() Dim sheett As Worksheet For Each sheett In Sheets() If sheett.Visible Then ' your code here End If Next sheett End Sub -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Steve" wrote in message ... I have a workbook with several hidden pages. I'm trying to write some vb code that will cycle though the Visible pages and ignore those that are hidden. Any help would be greatly appreciated. Thanks Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cycle time | Charts and Charting in Excel | |||
| Time Cycle | Excel Discussion (Misc queries) | |||
| How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
| Pages hidden with manual breaks still print | Excel Discussion (Misc queries) | |||
| How do I cycle through all of the worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
