untested, but just an observation;
I would expect the reference following RefersToR1C1 ro be in R1C1 notation,
but this appears to be in A1 notation.
Maybe try RefersTo instead of RefersToR1C1?

HTH,
Keith

"Ayo" wrote:

How can I fix this code line below. I am getting a "Run-time error '1004':"
"The formula you typed contains an error."
I tried putting quotes at the end and that didn't solve the problem.

ActiveWorkbook.Names.Add Name:="siteList",
RefersToR1C1:="=Error_MarketList!$A$5:$A$" & errorWS_lastRow