Code to hide rows

[dpaton05]

I need some code to hide some rows if some cells are blank.

• If C13 is blank, I need to hide row 25
• if C14 is blank I need to hide row 26
• If C15 is blank I need to hide row 27
• If C16 is blank, I need to hide row 28

Can someone help me with the code please?

 

[Michael M]

Works fine for me....so I'm guessing they're not blank ??
If you type in a cell somewher eles

=Len(C13)

.....do you get a result of 0 ??

 

[dpaton05]

I get 0

 

[Michael M]

In that case the code should work !!....can you upload the worksheet ??

 

[Michael M]

Dumb question, but you are using the correct range and / or columns, aren't you ??

 

[dpaton05]

Not sure what happened but it is working now, thanks anyway.