Hide rows based on cell value

[michelle 1]

HI

I have pasted the below code into the worksheet that i want to execue the code on, however it is not hiding/unhiding rows. Can someone point me in the right direction on what i may have missed please?

Please Login or Register  to view this content.

[BadlySpelledBuoy]

Did you paste the code in the worksheet module rather than in a standard module?

It works fine for me, but that really depends on what you're actually trying to do.

Do you want this to fire only when D10 is changed or when ANY cell is changed?

BSB

[BadlySpelledBuoy]

Assuming you only want the code to fire when D10 is changed, the below would work.

Please Login or Register  to view this content.

See attached for where the code needs to go (worksheet module)

BSB

[michelle 1]

Hi BSB

Thansk so much for yur response i have just pasted in that code and it works perfectly...not sure what was wrong with my original but i have replaced it with yours.

Thansk so much :-)

[BadlySpelledBuoy]

Happy to help

BSB