Hide Rows based on cell value being empty

[Legacy 102432]

Hi,

I have read other posts about this but I am still a little confused as most macros that have been made are tweaked to suite the users individual needs.

What I want is something like this to work in the active sheet:

If cells D2:D55 = ""
Then Hide.EntireRow

If cells D2:D55 = "has any value"
Then Show.EntireRow

The values in D2:D55 are populated by a VLOOKUP depending on what someone chooses in a drop down validation list, however not all the rows are always required so I would like to hide them to save some space on my form.

 

[Legacy 102432]

Your an absolute star!

Thanks i've put this in place and it works fine.

 

[sous2817]

HURRAY!! Glad it's working out...if you run across anything else, feel free to post back and hopefully someone can work out your issue.