| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unhide rows based on data validation
I have a data validation list in cell $E$30 of either "0" or "1".
If the user selects "0" I want to hide rows 144 - 238. If the user selects "1" I want rows 144-238 to appear. I tried the following code - but it didn't seem to work. Any help is appreciated. Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Range("E30").Value = "0" Then Range(Rows(144), Rows(238)).EntireRow.Hidden = True ElseIf Range("E30").Value = "1" Then Range(Rows(144), Rows(238)).EntireRow.Hidden = False: End If Application.ScreenUpdating = True End Sub -- Cathy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
| Hide/Show Rows based on Cell Value with Data Validation | Excel Programming | |||
| Data Validation based on data to left but several columns dependen | Excel Programming | |||
| Showing or Hiding rows based on data validation list | Excel Programming | |||
| Using VB to unhide hidden rows based on user response | Excel Programming | |||
Threaded Mode
