Results 1 to 10 of 10

Hide rows based on cell content

Threaded View

garyi Hide rows based on cell... 11-13-2010, 10:55 AM
MarvinP Re: Hide rows based on cell... 11-13-2010, 11:06 AM
royUK Re: Hide rows based on cell... 11-13-2010, 11:07 AM
garyi Re: Hide rows based on cell... 11-13-2010, 11:12 AM
MarvinP Re: Hide rows based on cell... 11-13-2010, 11:48 AM
garyi Re: Hide rows based on cell... 11-13-2010, 12:19 PM
MarvinP Re: Hide rows based on cell... 11-13-2010, 03:55 PM
garyi Re: Hide rows based on cell... 11-14-2010, 08:32 AM
garyi Re: Hide rows based on cell... 11-14-2010, 09:01 AM
garyi Re: Hide rows based on cell... 11-14-2010, 09:10 AM
  1. #1
    Forum Contributor
    Join Date
    08-31-2010
    Location
    andover
    MS-Off Ver
    Excel 2007
    Posts
    102

    Hide rows based on cell content

    Hello all, I know this has been asked a lot of times, and I have tried as many varients as I can find on line with no luck.

    I have a pop up box, with 5 choices. If one of those choices is selected then I need some rows to be hidden, I need this to happen automatically.

    here is the code I have tried (amongst others)


    Sub hidebreakfast()
    Application.ScreenUpdating = False
    Application.EnableEvents = False
    If Range("C13").Value = "never" Then
    Range("14:18").EntireRow.Hidden = True
        Else
    Range("14:18").EntireRow.Hidden = False
    End If
    Application.ScreenUpdating = True
    Application.EnableEvents = True
    End Sub
    In practice nothing happens, there is no error or anything, its just nothing happens.

    I do not need to reference the pop up box if it helps, in another cell if never is picked then number 1 is displayed. But I could not work it from this either.

    Many thanks
    Last edited by garyi; 11-13-2010 at 12:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1