VBA Row Hiding Code Not Responding As Expected

Hello.

I'm currently using VBA which is aimed at a Cell, B5. Once the Cell updates the code below hides or un-hides rows. However the section for CPC 0700000 does not want to do anything, but the code for CPC 4000000 and 7100000 works perfectly.
Can anyone point me in the direction of why this is not working as I expect it to?

Please Login or Register  to view this content.