+ Reply to Thread
Results 1 to 2 of 2

Hide Show rows based on cell value true or false using VBA

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    2

    Hide Show rows based on cell value true or false using VBA

    Hi,

    I am new to vba. I am preparing an excel sheet which has option button. When selecting and unselecting that option button, the assigned cell value show True or False respectively. if the particular cell value is false, I want to hide 3 rows whose range is dynamic. That means, the rows number that i need to hide changes, it is first 16:18 or 25:18. But it is only three continuous rows that I want to hide. But the value of cell in column 2 of the first row that I want to hide will be constant.

    Lets say, I want to hide rows 18:21, in which column 2 of the row 18 has value Bricks Masonry, I want to hide rows with Brick Masonry + next two rows based on cell value $C$8 if $C$8 is false.

    Please help me.

  2. #2
    Registered User
    Join Date
    12-18-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Hide Show rows based on cell value true or false using VBA

    anyone? please help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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