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.
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.
