View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Macro to Unhide MulipleRows if Cell B10 has a "X" otherwise hide c

Hi

Try this:

Sub aaa()
If Range("B10").Value = "X" Or Range("B11").Value = "X" Then
Rows("15:19").Hidden = False
Else
Rows("15:19").Hidden = True
End If
End Sub

Regards,
Per

"Leiprecht" skrev i meddelelsen
...
Trying to create a macro where if Cell B10 or B11 has an "X" then Rows
15-19
are unhiden. If B10 and B11 are both blank then rows 15-19 is hidden.