more than 2 workbooks

L

LiSa

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
 
J

JulieD

Hi Lisa

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

Cheers
JulieD
 
C

Chip Pearson

Lisa,

You're close. Try

Workbooks("Holidays.xls").Worksheets("Sheet1").Range("D9")


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