Creating a macro to hide rows in a specific range

P

PHUAG

Joined
Aug 5, 2011
Messages
1
Reaction score
0
HI,

Does anyone know how I can write a macro to perform the following:
For the range B5:G502, if any of the cells in Col B are blank, hide the entire row.


Thanks for your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Excel EXCEL - using a date dependant formula to hide rows 3
Macro to hide cols 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to hide rows with zero in specifc column range 2
Macro to insert a line when a value changes in a range 1
Macro to insert picture from specific folder 0

Top