Creating a macro to hide rows in a specific range

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