Conditional Hide Rows or Columns 1

[jacky89]

Can anyone tell me how to hide certain rows or columns when certain conditions are triggered? I've spent 10+ hours searching online but couldn't find any information on how to do this. Any help would be greatly appreciated!
THanks!

 

[PEStructural]

Does it hide the rest above and below?

 

[Harley78]

it hides all the above but not below

 

[Harley78]

or should I say 3244, 3245, 3246............. and so on are still showing

 

[PEStructural]

Is there anything typed into cell au3243? What about au3244? Any differences?

 

[Harley78]

au3243 is blank
au3244 has text inputed

 

[PEStructural]

If you are looking for a blank cell in column AU, isn't column AU the 47th column? Maybe that's the problem.

Also, if you have text in au3244, then it wouldn't hide per your macro, correct?

 

[Harley78]

You are correct.... 3244 is a drop down list and I must of miscounted on the column. "" is correct for blank cells, am I correct?

Many thanks for your help