View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Open sheets as per the range

Try this code...

If this post helps click Yes
--------------
Jacob Skaria


Dim intRow
intRow = 1
Do While Range("H" & intRow) < ""
ActiveWorkbook.Sheets("" & Range("H" & intRow) & "").Visible = True
intRow = intRow + 1
Loop