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;

Sub Worksheet_Change(ByVal Target As Range)
 
If (Target.Row = 26) And (Target.Column = 8) And _
 (Target = "No") Then

Worksheets("Pre-start & method statement p3").Rows(12).EntireRow.Hidden = True
 Else
Worksheets("Pre-start & method statement p3").Rows(12).EntireRow.Hidden = False
 End If
 End Sub

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

Any help would be greatly appreciated

Regards