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