Skip to content
VBA Excel How To Unhide Rows With If Condition
Post Views: 573
- Open Excel File
- Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.
- One Dialog Screen Will Get Open.
- Click Insert And Add Module.
- Create Sub Procedure With Any Name.
- Make Sure The Procedure Name Start With String And Without Space.
- Write The Code In Between Sub And Sub End.
- Click Run Button Or Insert A Form Button In Excel Sheet.
- Any Sub Procedure / Macro Can Be Assign To A Button.
- Then Goto Visual Basic Editor
- Prepare Sub Procedure.
- Sub Unhide_Rows_On_IF_Condition() End Sub
- In That Procedure Whatever Event You Want To Get Fire You Will Have To Right The Code According To It.
- In This Example We Will Unhide The Rows With For Loop Against If Condition.
- If You Want To Re Hide It Use This Code ActiveSheet.Range(“F”& i ).Rows.Hidden=True
- Note: Please Use Range & Sheets Name According To Your Requirements.
- That’s It 🙂
- Please Check The Images And Video For More Info.