Quote Originally Posted by Kerry H View Post
Do you mean write it as:

Rng1I = Workbooks("Centris").Sheets("INV INPUT").Range("H15:L214")
Most definitley NOT. For 2 reasons:
1. Your current code is only missing 4 dots (as shown in red).
2. Your line's missing the Set word.
and possibly a 3rd: Is the workbook called Centris, or Centris Periods?

How did you get on with adding those 3 temporary debugging lines?