more than 2 workbooks

  • Thread starter Thread starter LiSa
  • Start date Start date
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
 
Hi Lisa

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

Cheers
JulieD
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As and new workbook new name used in existing code 8
How to reference a cell from anther workbook without opening it 0
Reference a workbook level named variable. 8
Open four Wbooks, copy four columns from each to Master Wbook 16
Cell values to an array, then array transpose to another workbook 8
Import multiple workbooks to current workbook in specified row number 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copying cells and formula from closed workbook to all sheets in open workbook 0

Back
Top