Hi
I'm using an index(match) function in my sheet to lookup two values
from two other spreadsheets. The column reference in the Index function
needs to be obtained by a left(workbook,2), so it;s the first two
characters of the workbook name.

I have a macro that obtains this information in a variable (FName),
without dirtying the sheet i.e. using a FName = range("").value how can
I use the FName variable in the worksheet function?

Or if you have any other suggestions...

The overall aim is to cycle through about 160 workbooks, each workbook
needs to have the index function pasted through all rows.


Thanks


Wendy