Okay, then I need some help..."Range("B8:M8") would need to paste in Q4:AB4....Range("B45:M45") would need to paste in Q8:AB8 in the sheet referenced prior in the code.