Hi! I think the error is returned because the source doc is not activated. There are 2 solutions (though not tested by me): 1) before copyRange.Copy, insert a line to active WeeklyRotation, then insert another line to activate RWVB_Roster_Test & then paste the copied range; 2) (seems to be simpler) just move copyRange.Copy to be after copyRange.Select (thus, there's no need to activate the source doc). I hope either of the suggestions will work.