dynamically hide row

[fozze]

is there a way to dynamically (by formula or by vba) hide a certain row?

thx in advance!

[ibexcel]

why don't you place your condition in the worksheet_change routine ?

[fozze]

obviously, condition is not the problem. The problem is the code to hide the row

[Macdave_19]

Use this to hide the row

Please Login or Register  to view this content.

maybe reference the row number in a cell and use that in your code like:

Please Login or Register  to view this content.

I haven't ran the code but give it a blast!!! let me know how it goes?

[Macdave_19]

I just tried the code and it works a treat