more than 2 workbooks
 

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

more than 2 workbooks
 

Hi Lisa

try
Workbooks("Holidays.xls").Sheets("Sheet1").Range(" D9")

Cheers
JulieD


"LiSa" wrote in message
...
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

more than 2 workbooks
 

Lisa,

You're close. Try

Workbooks("Holidays.xls").Worksheets("Sheet1").Ran ge("D9")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"LiSa" wrote in message
...
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