I want to copy everything from sheet1 on one workbook and paste into another. I am getting subscript out of range error when trying to select the range to paste too.

Please Login or Register  to view this content.