Run-time error ‘438’ — “Object doesn’t support this property or method.”

[albertod8]

I am getting '438' error when running the following code, anyone would know how to fix it?

UsdRws = Range("A" & Rows.Count).End(xlUp).Row
Range("U2:U" & UsdRws).Formula1R1C1 = _
"=IFERROR(IFS(RC[-1]=""C"",RC[-10],RC[-1]=""B"",RC[-6]),""Not available"")"

 

[MARK858]

Remove the red 1

Formula1R1C1

 

[albertod8]

that was quick... you are right, should have picked that one

 

[MARK858]

You're welcome