Subscript out of range problem

[Kerry H]

I was referring to your comment about redundancy, which I didn't understand.
I did add the dots to the code I had previously.

Alternatively,does this work?

Set Rng1I = Workbooks("Centris").Sheets("INV INPUT").Range("H15:L214")

If so, are 2 of these statements better than the "With ...End" With structure?
BTW I didn't need the error tracking code. But I've saved it for another time!
When is the "Set" instruction used, generally?

Thanks foryour help.