Defining a range in a different open workbook from the active one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set a range in different workbook, PayRollCarryOver, from the
currently active one. PayRollCarryOver is open but not active.

What is the proper syntax for the link to another workbook?

I tried this, but got an error:

Set newCarryover = Range("[PayrollCarryOver.xls]'Carryover'!A1")

Thank you.

John Wirt
 
John,
Work you way through the Object Model:

Dim newCarryover as Range
Set newCarryover =
Workbooks("PayrollCarryOver.xls").Worksheets("Carryover").Range("A1")

NickHK
 

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

How to reference a cell from anther workbook without opening it 0
Import multiple workbooks to current workbook in specified row number 0
Copy user selected range from all open workbooks 2
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Creating a defined name's Refersto range 2
Error Opening Workbook 3
Macro shortcuts are running macros in different open workbook 3
Copy Multiple Areas from One Workbook to Another 4

Back
Top