Excel 2007 : VB code to hide rows that are empty or contain "-"

It helps to know how the values in that column get there, by manual insertion or by formula. But a generic way to examine all of column A on a given sheet would be:

Please Login or Register  to view this content.

Is there a reason for not just using an autofilter?

Thanks for the feed back folks. I'm new with VB. I'm using the following code (as it's the only one i seem to understand) but I get an error when I try to compile it. By the way the object is sheet1.

Run-Time error '424, Object required

Please Login or Register  to view this content.

What is Template supposed to be?

Also, you must use code tags when posting code on the forum. I have added them for you on this occasion, but you must use them yourself in future, please.

okay i removed the Template and not got a different error. Error 438, Object doesn't support this property or method. added quoted text around my code, hope that is what you meant by code tags.

Please Login or Register  to view this content.

Highlight your code and click the # at the top of your post window. For more information about these and other tags, see here

You can also just type them in:
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Your unprotect and protect part is incorrect - it should be:

Please Login or Register  to view this content.

and:

Please Login or Register  to view this content.

Why are you looping through the columns when you hide the entirerow?

Tried your suggestion but i still get the same error.

I only want to loop through the first column as there will be a formula that will return x if there is not data. I see what your mean. how do i modify my code to only loop through column 1?

thx

What did you actually try?