Syntax Error Help needed

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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
 
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
 
Hello:

If all you are trying to do is create a range dynamically, you could use
this simple method:

Public Sub Tester()

Dim errorWS_lastRow As Integer
Dim strRange As String

errorWS_lastRow = 20

strRange = "A5:A" & errorWS_lastRow

Range(strRange).Name = "sitelist"

End Sub
 
Back
Top