I have this code
Sub ifcitythencity()
If InStr(1, (range("A2").Value), "San Francisco") > 0 Then range.Value("B2") = "San Francisco"
End Sub
But when I run the debugger, I get the error "Compile error: Argument not optional," and it highlights the second "range." What's causing this error?
range("B2").Value = "San fran"