Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all.
I've made a macro that iterates through an entire workbook, sets active cell to A1, and zooms to 70%. It works great until I run into a hidden worksheet-- which we have plenty of in our workbooks. Is there a way that I can have it run through all worksheets(hidden/visible), regardless? Thank you. Here's my code---------------------------------------------- Dim i As Integer Dim count As Integer count = 1 For i = 1 To Sheets.count Sheets(i).Select Range("A1").Select ActiveWindow.Zoom = 70 Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Iterating through a collection (For Each) | Excel Programming | |||
iterating groups? | Excel Programming | |||
iterating checkboxes | Excel Discussion (Misc queries) | |||
ITERATING A SINGLE CELL! | Excel Programming | |||
Iterating Thru Cells | Excel Programming |