VBA to automatically Paste and Resize

[crvazquez954]

Hello everyone, I have an Excel project I'm working on which requires me to have a table on one tab and a proposal on another tab printed on the same page. Because the table has certain rows and columns that hide depending on the users input it's impossible for me to simply have the table and report next to each other and set them both in the same print area. It seems the only solution is to copy the table and paste it on the report. However, the problem I am having is getting the report to automatically resize if it extends past the reports print area. Can anyone help me write a VBA code that will copy A2:N44 in the "ProposalTable" tab and paste it in C184 of the "Proposal" tab and resize if necessary (i.e. if the width is more than 7.9")?