Hi and welcome to the forum.

The syntax for autoFill is:

Sub Macro1()
    Range("U2") = "No"
    Range("U2").AutoFill Destination:=Range("U2:U106"), Type:=xlFillDefault
End Sub