error '438', Object doesn't support this property or method.

I'm getting the following error msg: run-time error '438', Object doesn't support this property or method.

The function below should loop through the first column and hide the row if "x" exists. The sheet will have a formula on the first column that will evaluate if there is data returned. The sheet is an accounting balance sheet and some accounts do not return data so I would like to hide it. If there is a better way please let me know, this is the simplest piece of code that I can understand.

Please Login or Register  to view this content.