I am using a line of code that uses a variable to look at a set sheet and it
works great. The "TwoMonthsAgo" variable is what I am using to look at a
sheet named "Sep04"

Activecell.formulaR1C1 = "=VLOOKUP(RC1, ' " & TwoMonthsAgo & " ' !C1:C[82],
82, FALSE)"

Now I have another variable "TrendFile" that is the name of the workbook
that the "Sep04" sheet is in. The problem I am having in setting up the
VLOOKUP function from another workbook. I would like to be in workbook-A and
look at the "TrendFile" workbook on sheet "TwoMonthsAgo".

Thanks for any help you can give.

Hi Tony,

Activecell.formulaR1C1 = "=VLOOKUP(RC1, ' " & "['" & TrendFile & "]" &
TwoMonthsAgo & " ' !C1:C[82],
82, FALSE)"


--

HTH

RP

"Tony" wrote in message
...
I am using a line of code that uses a variable to look at a set sheet and
it
works great. The "TwoMonthsAgo" variable is what I am using to look at a
sheet named "Sep04"

Activecell.formulaR1C1 = "=VLOOKUP(RC1, ' " & TwoMonthsAgo & " '
!C1:C[82],
82, FALSE)"

Now I have another variable "TrendFile" that is the name of the workbook
that the "Sep04" sheet is in. The problem I am having in setting up the
VLOOKUP function from another workbook. I would like to be in workbook-A
and
look at the "TrendFile" workbook on sheet "TwoMonthsAgo".

Thanks for any help you can give.