Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type Mismatch | Excel Worksheet Functions | |||
Type Mismatch | Excel Programming | |||
Type mismatch | Excel Programming | |||
Type mismatch | Excel Programming |