VBA to Hide Blank Rows in Multiple Ranges of Spreadsheet

[EdwardSurrey]

Hello

I have a spreadsheet with four tables, each below one another.

Is it possible with VBA to press a button which will check whether there are any blanks in Column B (within each of the table ranges) and hide the relevant rows? I need the macro to work every time I initiate it, looking in Column B for rows it previously hide and unhiding any rows that now have data.

Also, because I may be inserting rows into the spreadsheet it would be good if the VBA could keep the range references. I've seen some VBA referencing specific cells which may move around, not being updated within the VBA.

Sorry for all the criteria, and hopefully for someone out there this is a simple fix! Thanks

 

[EdwardSurrey]

I have managed to solve it.

Hello

I have a spreadsheet with four tables, each below one another.

Is it possible with VBA to press a button which will check whether there are any blanks in Column B (within each of the table ranges) and hide the relevant rows? I need the macro to work every time I initiate it, looking in Column B for rows it previously hide and unhiding any rows that now have data.

Also, because I may be inserting rows into the spreadsheet it would be good if the VBA could keep the range references. I've seen some VBA referencing specific cells which may move around, not being updated within the VBA.

Sorry for all the criteria, and hopefully for someone out there this is a simple fix! Thank