Hi

I have a macro which trails through x number of spreadsheets and updates
the current months values into a data book which is then linked to an output.

In the control sheet of my workbook i have a looping function which iterates
through each of the workbooks - however in the vlookup I am having difficulty
referencing the relevant workbook as a variable

The formula is as

Windows("MyWorkBooks").Activate
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-11],"REPORTNAME"! R33C3:R84C12,10,0)"

Where

Dim ReportName As String
ReportName = xxxxx.Value


Any suggestions as to what I am doing wrong ?

Many thanks in advance

Hardeep