Hiding row in a sheet based on cell selection in another sheet

Hi

I have a code working however, a "runtime error" of "13" keep appearing and i cannot figure it out for the life of me. The code i have is;

Please Login or Register  to view this content.

The error seems to appear if it type anything into any other cell and then delete it?

Any help would be greatly appreciated

Regards

Can't seem to spot any problems, is your worksheet named like this, Pre-start & method statement p3 ? If yes, is the worksheet protected?

The file is too large to upload apparently

The sheets are named as they are in the macro and the works sheets are not protected at the moment

Which line is the error highlighting?

Hi

Its highlighting

Please Login or Register  to view this content.

Try changing it to a single line?

Please Login or Register  to view this content.

Tried - error still showing

I just tried the exact same code and is not getting any error. Maybe post a sample workbook with any huge amount of data removed?

RAMS (master) - example.xls

See attached workbook.

The error occurs when sub-contractors is set to "No" (i.e. to hide the line) and a date is put in to "start date" and then deleted

Odd enough, it's working fine when I try your workbook. Problem could be with the data validations.
The data validation in the cell for sub-contractors was ripped to this

Please Login or Register  to view this content.

when you removed sensitive information (I believe). So I manually changed the validation list to a simple "yes" and "no". When I choose yes, this was properly shown

Liase with sub-contractors and ensure their RAM's are available. Refer to p2 for permit requirements & p1 for sub-contractor details. PPE and adherence to RAM's to be supervised at all times

in the worksheet "Pre-start & method statement p3", and likewise, properly hidden when I chose no.

So now I can't really figure out what's the problem on your side.

Hi - yes, the code works. The error only appears when another cell on the sheet is populated and then deleted?

Ok. try this.

Please Login or Register  to view this content.

It works!! what was changed?

Well the reason it's throwing an error only when you delete something is because then Target would be a Null/Nothing. And comparing a Null with a string like "No" returns in an error (Type mismatch).
So moving the checking of "No" into a second If statement will ensure that it goes past the first If statement and is definitely not a Null value as it's validated by the Data validation in cell H26.