Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping Problem . . .Argh!
I am using the following code to cycle through open sheets and hide those
with nothing in Cell A2. When I run the code, it never changes sheets, it just applies the logic to the same sheet. Dim SH As Worksheet Dim xlRng As Object 'Excel.Range Dim xlApp As Excel.Application For Each SH In xlApp.ActiveWorkbook.Worksheets Set xlRng = xlApp.Range("A2") If xlRng = "" Then xlApp.ActiveWindow.SelectedSheets.Visible = False Next SH Any Ideas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scrolling Looping Problem | Excel Discussion (Misc queries) | |||
If Then Else looping problem | Excel Programming | |||
Argh...layering object problem in userform | Excel Programming | |||
complex looping problem | Excel Programming | |||
Looping Problem | Excel Programming |