Hello

I have a workbook which opens two more workbooks, making a
total of 3.

How can I reference a range on a the workbook that is
neither the ActiveWorkbook or ThisWorkbook (ie the one the
code is in.

So far I've tried
Workbooks "Holidays.xls" .sheet1.Range("d9")

but get a syntax error.

TIA