Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax Error Help needed
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax Error Help needed
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax Error Help needed
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 -- Rich Locus Logicwurks, LLC "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AppActivate syntax - help needed | Excel Programming | |||
VBA code to sum a row: syntax needed | Excel Discussion (Misc queries) | |||
Please explain syntax needed | Excel Programming | |||
Multiple Condition syntax needed | Excel Programming | |||
Syntax needed for With | Excel Programming |