Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows won't hide
Hello my code is
Private Sub Worksheet_Change(ByVal Target As Range) If (Range("F365") = "No") Then myArr = Array("12", "15", "17","33","45","89") EntireRow.Hidden = True End If End Sub and it does not work..... This is what I want to do If F365 = "No" then hide rows 12,15,17,33,45,89 the range is a1:X360 thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Rows | Excel Discussion (Misc queries) | |||
cut rows without cutting hide rows | Excel Discussion (Misc queries) | |||
hide rows if | Excel Discussion (Misc queries) | |||
Hide the rows | Excel Worksheet Functions | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions |