Hiding Rows Based based upon cell value being blank

Hi all,

I have a problem:

From the click of a button I require the macro to look at a pre-setup sheet (b) which has results from the first sheet (a)

The table goes from Column A:U, and Rows 2:181

What I require is: If B2 is blank hide row 2, If B3 is blank hide row 3... so on and so on until... If B181 is blank hide row 181


Any help would be grealy appreciated!

Thanks,

Lee

Try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks for that antoka05, that's good.

There is one problem with that though... it seems to do something, but nothing is hidden from it. I have B2, B22 and B42 with text in it, but when I press the button rows 2:181 are hidden.

Please can you advise what to change?

Thanks,

Lee

Thanks broro183, that works a treat

I have no idea because there is that issue... please try with this code (it tests cells in column 'B'):

Please Login or Register  to view this content.

Regards,
Antonio

Thanks Antonio, but it didn't work. I think I'll stick to broro183's use of AutoFilter.

Lee