Thread: Defining a range in a different open workbook from the active one
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JWirt JWirt is offline
external usenet poster
  
Posts: 8
Default Defining a range in a different open workbook from the active one
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
Reply With QuoteReply With Quote