VBA code in HIDING & UNHIDING row if value is zero

Move your code to the sheet specific area for now.

Right Click on the sheet name at the bottom of excel and select view code.

Select worksheet on the left tab

select change on the right tab.

place your code inside the macro that is shown

Your macro will now run whenever the sheet is changed.

I will look at speeding it up for you.

This is not as fast as I would like

but a lot faster than you version.

S

Enjoy.

Hi mehmetcik!

rows 1-24 should not be hide no matter what the values are, only rows 25-438 will be moving.