If cannot find string...set to 0

[NewbieMan]

Hi,

Stuck writing the IF statement for the following code

'Total Wins
findrow = Range("A:A").Find("Career").Offset(0, 4).Select
ActiveCell.Copy
Range("T5").PasteSpecial
findrow2 = Range("A:A").Find("2017-18").Offset(0, 4).Select
ActiveCell.Copy
Range("T4").PasteSpecial
Range("T3").Value = Range("T5").Value - Range("T4").Value

Could someone help to rewrite this so that IF the string 2017-18 cannot be found, then sub in the value of 0 "zero" for cell T4 otherwise continue as is. Right now it kicks out an error.

Thanks in advance

 

[mrshl9898]

A bit of a workaround, would this suit?

findrow = Range("A:A").Find("Career").Offset(0, 4).SelectActiveCell.Copy
Range("T5").PasteSpecial
On Error Resume Next
findrow2 = Range("A:A").Find("2017-18").Offset(0, 4).Select
If findrow2 <> "" Then
ActiveCell.Copy
Range("T4").PasteSpecial
Else
Range("T4").Value = 0
End If
Range("T3").Value = Range("T5").Value - Range("T4").Value

 

[NewbieMan]

thank you my friend.