John,
Work you way through the Object Model:

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

NickHK

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