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