Thread: Type mismatch?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Wirt[_9_] John Wirt[_9_] is offline
external usenet poster
 
Posts: 2
Default Type mismatch?

When I run this code, I get an error="Type mismatch." How come?

Public Sub HideSelectedSheets()
Dim Wsh As Worksheet
For Each Wsh In ActiveWorkbook.Sheets
If UCase(Wsh.Range("G1").Value) = "HIDE" Then
Wsh.Visible = xlSheetHidden
End If
Next
End Sub

Thank you.

John Wirt