+ Reply to Thread
Results 1 to 3 of 3

hide/unhide rows based on multiple cell values

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    2

    hide/unhide rows based on multiple cell values

    Hello

    This is my first time in this forum. I searched for my query within existing threads, but could not find an answer.

    My file contains a workbook - misc1

    Cell B8 is a dropdown list. If the value selected is "Toyota"
    And
    Cell C24 is a currency (with two decimal places). If the value is less than or equal to $20,000.00 (we key in the value in this cell).
    Then
    Hide rows 26 to 29
    Else
    Hide rows 35 to 38.

    Can you please help me with the code for this.

    Thanks

    San

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: hide/unhide rows based on multiple cell values

    Do you want the hide/unhide to happen on every change in the dropdown in cell B8?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    06-19-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: hide/unhide rows based on multiple cell values

    Yes every time someone picks from drop down or enters a value in these two cells

+ Reply to Thread

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