View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Aaron[_6_] Aaron[_6_] is offline
external usenet poster
 
Posts: 4
Default Reference to a range in another workbook


Huyeote

If your not familiar with Visual basic you can use an
indirect.ext worksheet function which allow's you to use
references to external workbooks closed or open.

You'd need to add an additional add inn for this function
so if you'd like it let me know

Rgds

Aaron

-----Original Message-----
Hi, there, I need to insert a VLOOKUP formula to a range

of cells in a
worksheet in workbook1. The looked up area is a range in

workbook2. The
formula string looks like "=VLOOKUP(RC[-1],
'[Workbook2]Sheet1!R1C1:R55C7',8,FALSE". The address of

the looked up area
changes frequently. How can I use a variable to replace

the long string of
the address? How many ways to do it? Thanks in advance.

Regards

Huyeote


.