| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax error
What is wrong with this line.It gives me a syntax error
ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Just guessing;
"=if(iserror(VLOOKUP(RC1,[ should be "=if(iserror(VLOOKUP(R1C1,[ HTH Regards, Howard "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
is data_rng a defined name in your workbook. If you do
Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
If data_rng is an object variable of type range, then
. . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
I bet you still want to drop the .range() stuff.
<vbg And maybe the external:=true???? (depending on what data_rng is/was/will be??) Tom Ogilvy wrote: If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Not on the first suggestion although if it were a defined name you would -
my misread of the formula string. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... I bet you still want to drop the .range() stuff. <vbg And maybe the external:=true???? (depending on what data_rng is/was/will be??) Tom Ogilvy wrote: If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Just disregard my posts. I should have started over.
-- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Have a good night's sleep and go get 'em tomorrow????
<gd&r Tom Ogilvy wrote: Just disregard my posts. I should have started over. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
I really apprecite everyone's comments. I will try some of the
suggestions tomorrow. Thank a million. ~ Pablo Dave Peterson ha escrito: Have a good night's sleep and go get 'em tomorrow???? <gd&r Tom Ogilvy wrote: Just disregard my posts. I should have started over. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . should actually probably be If data_rng is an object variable of type range, then . . .range(" & data_rng.Address(1,1,xlR1C1,True) & "),. . . -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
For that second suggestion, I think Tom meant:
....[abretesesamo.xls]Sheet1!" & data_rng.address(ReferenceStyle:=xlR1C1) & _ ",2,false)).... Tom Ogilvy wrote: is data_rng a defined name in your workbook. If you do Insert=Name=define, is there name data_rng listed there. If not, then that is your problem. If data_rng is a string variable, then you would need. . . .range(" & data_rng & "),. . . in each case. If data_rng is an object variable of type range, then . . .range(" & data_rng.Address & "),. . . -- Regards, Tom Ogilvly "Pablo" wrote in message ups.com... What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Syntax error
Just a variation of Tom's suggestion.
If data_rng is a named range (Insert|name|define), then drop the range() from the formular1c1: ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[book2.xls]Sheet1!data_rng,2,FALSE))," _ & """"",VLOOKUP(RC1,[book2.xls]Sheet1!data_rng,2,FALSE))" (You were missing a closing parentheses at the end, too.) === If data_rng is a variable that represents a range on sheet1 of the abretesemamo.xls workbook, then maybe you could do it this way: dim data_rng as range with workbooks("abretesesamo.xls").worksheets("sheet1") set data_rng = .range("A1:B999") 'or even .range("somename") set data_rng = .range("somename") 'or just for overkill... 'the variable has the same spelling as the named range! 'it might make it easier to keep track of things set data_rng = .range("data_rng") end with ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1," & _ data_rng.Address(external:=True, ReferenceStyle:=xlR1C1) & ",2,FALSE))," _ & """"",VLOOKUP(RC1," & _ data_rng.Address(external:=True, ReferenceStyle:=xlR1C1) & ",2,FALSE))" Pablo wrote: What is wrong with this line.It gives me a syntax error ActiveCell.FormulaR1C1 = _ "=if(iserror(VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)), _ """",VLOOKUP(RC1,[abretesesamo.xls]Sheet1!range(data_rng),2,FALSE)" Thanks for your help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| syntax error - help | Excel Discussion (Misc queries) | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| runtime error: syntax error or access violation | Excel Programming | |||
| variable not declared error & syntax error | Excel Programming | |||
| Syntax Error Runtime Error '424' Object Required | Excel Programming | |||
Hybrid Mode
