Hi,

I created a macro hiding rows based on cell value. In the beginning it worked correctly, yet after adding comments in some of the rows it crashes. I think the problem are the comment boxes, as when I delete them, the macro works properly again.

The code is as below:

Please Login or Register  to view this content.
and the debug is on the row:

Please Login or Register  to view this content.
Any ideas how to solve it?