View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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